469,273 Members | 1,755 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,273 developers. It's quick & easy.

Grand Total

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
4 2072
have a look at DSUM in the help file.

Nov 13 '05 #2
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
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
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.

Similar topics

3 posts views Thread by kkshansid | last post: by
2 posts views Thread by Bytesmiths | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.