Grand Total Field ???

[damo1995]

Hi there as the topic says i am attempting to create a grand total field in my form from multiple data entrys in a subform,
here is what my form looks like with multiple rows of data,

as you can see i have a space for grand total but i dont know how or



what forumula i would use to calculate it does anybody have any ideas ?
Thanks

[NoellaG]

Hi,

Try DSum("Fieldname","Domain","Condition")

greetings
NG

[damo1995]

Hi,

Try DSum("Fieldname","Domain","Condition")

greetings
NG

What exactley has to go into the domain and condition Values ?

[NoellaG]

Hi,

the domain is the name of the table or query where the field can be found, the condition will probably in your case be someting like "[Customer] = " & me.lstNameOfCustomerList

I think you can find some examples of domain functions using the Help feature.

greetings
NG

[damo1995]

i beleve that may be a problem as the total field that calculates the Single item cost * Quantity sold is not saved its just temp saved there, so would it not be posible just to pull the values out of the data rows and then add them together ? (Gosh Excel is easy )

[NoellaG]

Hi,

you can make any calculation you want in Access, and use nested formula's just like in Excel. Access even possesses some extra functions taht aren't available in Excel, like the NZ function...

just lookup the help functions, and maybe buy or borrow a good Access handbook.

success
NG

[damo1995]

Hi,

you can make any calculation you want in Access, and use nested formula's just like in Excel. Access even possesses some extra functions taht aren't available in Excel, like the NZ function...

just lookup the help functions, and maybe buy or borrow a good Access handbook.

success
NG

Do you know any good Handbook would be nice to actually get a handbook on how to use it and all the formula's