Dsum Problems

[Ganymede]

I'm currently using a DSum formula on a form that functions correctly. It appears as:

DSum("Amount","InformalInquiriesSubform","Key = [Text2020]")

I want to use the same function to obtain the same data in a query expression. However, instead of using Text2020, I want to reference the field that Text2020 represents. I would think that would look like this.

DSum("Amount","InformalInquiriesSubform","Key = [Key]")

Unfortunately, access doesn't recognize this criteria. It simply returns the sum of all "Amounts" on the "Informal Inquiries Subform." I imagine the problem is that there is a different method for entering criteria when using a field from a table as opposed to a textbox on a form. I'm trying to figure out what that is.

[pbaldy]

Concatenate the value, like here:

DLookup Usage Samples

[Ganymede]

That did it. Thanks.

DSum("Amount","InformalInquiriesSubform","Key = " & [Key])

[pbaldy]

Happy to help.