Grand Total

[lyndsey]

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

[pietlinden]

have a look at DSUM in the help file.

[lyndsey]

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
[e-mail] wrote:

have a look at DSUM in the help file.

[Bugs]

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
[e-mail] wrote:

have a look at DSUM in the help file.

[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
[e-mail] 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