DSUM advice

[esmith7912]

What I really need is a SUMIF, but it looks like a DSUM may be able to help... I want to sum invoice amounts from an invoice table when the id from the original table = the id from the invoice table.

Below is a picture of what I'm trying to do:

http://www.imagehoop.com/view_image/19db81144/untitled.JPG

The DSUM formula I've tried looks like this:

Total Invoice Amount: DSum("[Invoice Amount]","[tbl Invoice]","[tbl Invoice]![DB ID] =[DB ID]")

This gives me the sum of all of the invoices for every line, not when the DB ID from the "tbl Invoice" table equals the DB ID from the budget table

Anyone have advice on how to make the criteria match on the id's?

Thank you!

[dima69]

What I really need is a SUMIF, but it looks like a DSUM may be able to help... I want to sum invoice amounts from an invoice table when the id from the original table = the id from the invoice table.

Below is a picture of what I'm trying to do:

http://www.imagehoop.com/view_image/19db81144/untitled.JPG

The DSUM formula I've tried looks like this:

Total Invoice Amount: DSum("[Invoice Amount]","[tbl Invoice]","[tbl Invoice]![DB ID] =[DB ID]")

This gives me the sum of all of the invoices for every line, not when the DB ID from the "tbl Invoice" table equals the DB ID from the budget table

Anyone have advice on how to make the criteria match on the id's?

Thank you!

Not quite sure what you need to do. I guess you want to put that sum into calculated field on the form, am I right ?
Anyway, the criteria you put there "[tbl Invoice]![DB ID] =[DB ID]" cannot work because both [tbl Invoice]![DB ID] and [DB ID] at this context refer to [tbl Invoice], i.e. the equasion is always true.
I think that what you need here is something like "[DB ID] = " & Me![DB ID]

[esmith7912]

I just figured it out, my formula looks like this:

DSum("[Invoice Amount]","[tbl Invoice]","[tbl Invoice]![DB ID] =" & [DB ID] & "")

Thank you for your help.