By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,489 Members | 1,954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,489 IT Pros & Developers. It's quick & easy.

Grand Total

P: n/a
i have a database to keep record of jobs in production, and on one of
my forms, their is the control [Total Price]. in my form i have
hundereds of records (jobs). is there a way i can create something in
my record that will show me the grand total price of all the jobs in
production.

Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
have a look at DSUM in the help file.

Nov 13 '05 #2

P: n/a
I have tried to use =DSum("[Total Price]","Jobs In Production") but
when i type into the total price field the grand total remains blank.

Thanks
pietlin...@hotmail.com wrote:
have a look at DSUM in the help file.


Nov 13 '05 #3

P: n/a
Hi

Try putting the dsum code in the form open and form after update events

It will only update the total once u exit the current record.

Hope this helps.

Cheers.
"lyndsey" <ly*****@mgmplc.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
I have tried to use =DSum("[Total Price]","Jobs In Production") but
when i type into the total price field the grand total remains blank.

Thanks
pietlin...@hotmail.com wrote:
have a look at DSUM in the help file.

Nov 13 '05 #4

P: n/a
Br
Bugs <bu*****@optusnet.com.au> wrote:
Hi

Try putting the dsum code in the form open and form after update
events

It will only update the total once u exit the current record.

Hope this helps.

Cheers.
"lyndsey" <ly*****@mgmplc.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
I have tried to use =DSum("[Total Price]","Jobs In Production") but
when i type into the total price field the grand total remains blank.

Thanks
pietlin...@hotmail.com wrote:
have a look at DSUM in the help file.


Have you tried issuing a Me.ReCalc on the afterupdate event of the total
price?
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.