G
Guest
I am trying to add a calculated control on a main form that pulls its
information from the subform. The subform is in datasheet view and I am
pulling the information from a caluclated control in it as well. Essently I
want it to work just like a recipt where the subform produces a total cost
per items purchased (there can be more than one item) and the main form
produces a total of all items purchased. I have tried the Sum() function and
that is not working. I see info about the DSum function on preivious post
but can't seem to find more indeath info to make sure I am doing it right.
Could anyone please help?
P.S. I would also like to know if it is possible to store a calculated
field. I have another section that will work like this but I will need to be
able to access the total as a seperate peice of information for something
else and don't want to have to have it recalculate everytime I do that
information from the subform. The subform is in datasheet view and I am
pulling the information from a caluclated control in it as well. Essently I
want it to work just like a recipt where the subform produces a total cost
per items purchased (there can be more than one item) and the main form
produces a total of all items purchased. I have tried the Sum() function and
that is not working. I see info about the DSum function on preivious post
but can't seem to find more indeath info to make sure I am doing it right.
Could anyone please help?
P.S. I would also like to know if it is possible to store a calculated
field. I have another section that will work like this but I will need to be
able to access the total as a seperate peice of information for something
else and don't want to have to have it recalculate everytime I do that