how do i add mutiple fields together?

[tcarradine]

my first post...

sorry if this question has either been asked before or if i'm just a total lame for not knowing. i browsed around the forum first but i probably just don't know how to ask the right question if you know what i mean. my access knowledge is basic to to say the least... well, here goes:

i've got a "job number/work order detail" style db setup with two tables, one for the job details (job_number, open_date, closed_date etc...) and one for the type of work preformed and the number of hours spent on each (work_date, setup_hrs, drive_time etc...). this works great for looking at/editing the data but i've been asked to setup a report that sumerizes the total number of hours spent on a given job.

i've got a report setup that shows the details of the job preformed just like the form i enter it on. what i'm not sure how to do is to get access to take all of the results of a certain type (i.e. setup_hrs) accross each of the work_order_detail fields that are joined by the woID field and give me a grand total.

this seems like it should be easy, but i really have no idea how to go about it...

any help would be appriciated!

thanks!

Tim

 

[ScottGem]

Group on your job number and in the Job footer use:

=Sum([amountfield])

 

[tcarradine]

scott, you're my hero!

Tim

 

[tcarradine]

hey, on this same vein, how would you sum all of the totals together.

i'm trying:

=Sum([setup_hrs]+[drive_time])

which seems like it's working okay (with that it gives me a correct sum) but when i add another field to the list like:

=Sum([setup_hrs]+[drive_time]+[drafting])

it 2 to the previous sum (when the value is 7 on my test)...

huh?

thanks!

Tim

 

[ScottGem]

Depends on what you are trying to sum. If you are trying to add together all the sums in the footer, then you should use:

=Sum([fieldname1]) + Sum([Fieldname2]) etc.

or

=Controlname1 + controlname2

use the names of the controls you placed in the footer.

 

[Pat Hartman]

The problem is that you need to account for the possibility of one of the arguments being null. Use the Nz() function.
=Sum(Nz([setup_hrs],0)+Nz([drive_time],0)+Nz([drafting],0))

 

[Jass7869]

I tried and it didn't work for me for some reason

 

[ScottGem]

Jass,
This is a 9 year old thread. If something didn't work for you. Please ask a new question detailing what you tried and why it didn't work.