Hi, HELP!!!

I'm trying to find a way of totaling field a if field b = 1 for example, however I cannot get it to work, I think the fact that the form I am trying to find this sum for is in a sub form is not helping!

Any ideas?

Regards
H.

PS both fields are in a subform!

If you are doing this ina subform footer, you should be able to do something like:

=sum([MyFldName])


???

Thanks, cracked it!

Just could not get it to work, was banging my head against a brick wall for about three hours!!!

=DSum("[variation]","[job sheet]","[creditnumber] = 2")

Cheers
H

Cool - Glad you got it working. :)

Hi,

Second part of the problem has arisen!!!!

DSUM seems to be summing all the instance where there is "2"

However I need it to sum only in the current recordset that is in my subform!

Any ideas?

H.

Looks like you should be using simple a sum instead of a dsum...

Maybe:

=Sum("[variation]")

Thanks for the info!

However... used the DSum but added some Criteria, many thanks for the help.

I did try using the sum method however it didnt work (well may be I was just not clever enough to work out how to do it!)

Over come that, now I found one of my relationships doesnt work correctly! Oh well leave that one til Wednesday!

H.