Hi there,
It seems that my database is running ok, but, when I want to print my inform, it prints the data ok but at the end it jumps to the next page like page and a half, and I just want to stop printing in the last data.
Can you help me,
Thanks in advanced,
Erick.
I have done everything I know to get a total in my main invoice report, but still cant make it right.
I tried to repeat the process I did when I calculate the total in my main form, but I couldn't made it.
I send you a sample of my database for you to know exactly where is my problem and how...
Hola Linda,
your help was really good, but still cant make it work. if you want I can send you a sample of what I've done, for you to know exactly, where is the problem.
Thanks your help.
Erick.
Hello John,
I have searched about this unique identifier, but I couldn't find where its located, I got in the macro window, and I tried to filter the registers , but I couldn't do it, I read the access help about this, but still dont know how to do it.
I have the report, but still shows all...
Hello,
I've been trying to print a single record of a form with the specific data on the screen but with different format on printing.
I have done a report with the wizard, with the two queries I needed in the form, but the thing is that the report gets all the records and I just need: the...
hello, Gus!
Northwind, was helpfull to get the mystake that I had on my subform, but still can't make it right.
I did what you told me, step by step on your last 2 messages, but, as I see a control with the Sum() function does not sum controls with operations. I just get an Error# message in...
I believe i found the problem, the thing is that the function SUM( ), does not sum an unbound control with an operation, and i have a division to sum.
what i have in the unbound control "des" : [price]/1.15 and i want to get a subtotal of : sum [qty]*[des] but cant make it right, just...
I have to sum a control that has a division, but it seems that the function sum() does not sum a unbounded control with an operation.
Can you help me?
Thanks in advance.
Erick.
If you want to Sum fields in a form, put the unbound control in the footer of the form. Or if it is a subform, put it in the footer of the subform. Your calculation above should be SUM([Price]*[Qty]) (notice the brackets around EACH field name)
As to why you can't see the field...do you maybe...
i have to calculate the sum of many records on a subform
for an invoice form.
I been doing everything I found possible with the access help , but still can make it right.
Dont know exactly where is the root of the problem!
What should i use?
the "total" control must to be an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.