Hello everyone,

I'm hoping someone can help!  I'm sure there is an easy answer to my
question,
but I can't figure it out tonight.  I have a form/subform.  My database is
keeping track of loads of concrete that trucks haul into a job.  My form has
a
job number and location. . . my subform has a load number, date, truck
number,
yards hauled.  What I want to do is put a text box in the form that keeps a
total of the yards hauled for the day to whatever job the form is on.  I
also
want to put a column in my subform (datasheet) that shows the running total
as
each truck is logged.  What is the best way to go about this?

Thanks for any help!
Jamie Kriegel

Hi Jamie,

I think your best bet is to use a domain aggregate function - DSUM.  You'll
specify the table on which your sub form is based as the data source and the
job number on the main form as your criteria. Look it up in help and watch
that you get all the quotes just right.

NB - domain aggregates are quite slow - if you've got very large numbers of
records to look at it can take some time to calculate.





Regards

Richard Gibson
IT Manager


The information in this message is confidential and intended for the
addressee only.  If you have received this message in error please delete
and notify the sender, any other action may be unlawful.

The views expressed in this message are personal and not necessarily those
of Walkerpack Ltd unless explicitly stated.


-----Original Message-----
From: Jamie Kriegel [mailto:jamiek@m...]
Sent: 20 May 2002 14:28
To: Access
Subject: [access] Help with Form Calculations


Hello everyone,

I'm hoping someone can help!  I'm sure there is an easy answer to my
question,
but I can't figure it out tonight.  I have a form/subform.  My database is
keeping track of loads of concrete that trucks haul into a job.  My form has
a
job number and location. . . my subform has a load number, date, truck
number,
yards hauled.  What I want to do is put a text box in the form that keeps a
total of the yards hauled for the day to whatever job the form is on.  I
also
want to put a column in my subform (datasheet) that shows the running total
as
each truck is logged.  What is the best way to go about this?

Thanks for any help!
Jamie Kriegel

Thanks Richard,

I ended up getting it to work by putting a sum calculation in the footer of
the subform. . . this wasn't visible in datasheet view, so I created a text
box in the main form footer that referenced the data in my calculation
field.  It works great, but now I've run into another snag. . . I've
designed the form to open to a certain record based on a value in another
form.  When I set this criteria, my running total quits.  As long as I leave
out the criteria it works fine.  Does this make sense?  I could email you my
database off list if you think that will help.

Thanks for your help,
Jamie

-----Original Message-----
From: Richard Gibson [mailto:rgibson@W...]
Sent: Monday, May 20, 2002 10:28 AM
To: Access
Subject: [access] RE: Help with Form Calculations


Hi Jamie,

I think your best bet is to use a domain aggregate function - DSUM.  You'll
specify the table on which your sub form is based as the data source and the
job number on the main form as your criteria. Look it up in help and watch
that you get all the quotes just right.

NB - domain aggregates are quite slow - if you've got very large numbers of
records to look at it can take some time to calculate.





Regards

Richard Gibson
IT Manager


The information in this message is confidential and intended for the
addressee only.  If you have received this message in error please delete
and notify the sender, any other action may be unlawful.

The views expressed in this message are personal and not necessarily those
of Walkerpack Ltd unless explicitly stated.


-----Original Message-----
From: Jamie Kriegel [mailto:jamiek@m...]
Sent: 20 May 2002 14:28
To: Access
Subject: [access] Help with Form Calculations


Hello everyone,

I'm hoping someone can help!  I'm sure there is an easy answer to my
question,
but I can't figure it out tonight.  I have a form/subform.  My database is
keeping track of loads of concrete that trucks haul into a job.  My form has
a
job number and location. . . my subform has a load number, date, truck
number,
yards hauled.  What I want to do is put a text box in the form that keeps a
total of the yards hauled for the day to whatever job the form is on.  I
also
want to put a column in my subform (datasheet) that shows the running total
as
each truck is logged.  What is the best way to go about this?

Thanks for any help!
Jamie Kriegel

send it to me and I'll have a look

rgibson@w...  (in case that doesn't show on the reply)





Regards

Richard Gibson
IT Manager


The information in this message is confidential and intended for the
addressee only.  If you have received this message in error please delete
and notify the sender, any other action may be unlawful.

The views expressed in this message are personal and not necessarily those
of Walkerpack Ltd unless explicitly stated.


-----Original Message-----
From: Jamie Kriegel [mailto:jamiek@m...]
Sent: 20 May 2002 16:54
To: Access
Subject: [access] RE: Help with Form Calculations


Thanks Richard,

I ended up getting it to work by putting a sum calculation in the footer of
the subform. . . this wasn't visible in datasheet view, so I created a text
box in the main form footer that referenced the data in my calculation
field.  It works great, but now I've run into another snag. . . I've
designed the form to open to a certain record based on a value in another
form.  When I set this criteria, my running total quits.  As long as I leave
out the criteria it works fine.  Does this make sense?  I could email you my
database off list if you think that will help.

Thanks for your help,
Jamie

-----Original Message-----
From: Richard Gibson [mailto:rgibson@W...]
Sent: Monday, May 20, 2002 10:28 AM
To: Access
Subject: [access] RE: Help with Form Calculations


Hi Jamie,

I think your best bet is to use a domain aggregate function - DSUM.  You'll
specify the table on which your sub form is based as the data source and the
job number on the main form as your criteria. Look it up in help and watch
that you get all the quotes just right.

NB - domain aggregates are quite slow - if you've got very large numbers of
records to look at it can take some time to calculate.





Regards

Richard Gibson
IT Manager


The information in this message is confidential and intended for the
addressee only.  If you have received this message in error please delete
and notify the sender, any other action may be unlawful.

The views expressed in this message are personal and not necessarily those
of Walkerpack Ltd unless explicitly stated.


-----Original Message-----
From: Jamie Kriegel [mailto:jamiek@m...]
Sent: 20 May 2002 14:28
To: Access
Subject: [access] Help with Form Calculations


Hello everyone,

I'm hoping someone can help!  I'm sure there is an easy answer to my
question,
but I can't figure it out tonight.  I have a form/subform.  My database is
keeping track of loads of concrete that trucks haul into a job.  My form has
a
job number and location. . . my subform has a load number, date, truck
number,
yards hauled.  What I want to do is put a text box in the form that keeps a
total of the yards hauled for the day to whatever job the form is on.  I
also
want to put a column in my subform (datasheet) that shows the running total
as
each truck is logged.  What is the best way to go about this?

Thanks for any help!
Jamie Kriegel