DSum Acting Weird

[DS]

I have a DSum Expression that Im using based on a Query. It works fine
whenever I'm focused on a record that contains the Criteria of "Main",
however when I I'm focused on a record that doesn't have the Criteria of
"Main" my field containing the DSum Expression come up blank. I need
that field to always show the total number of records containing "Main".
How can I accomplish this?

=DSum("Quantity","MainItemCountQ",[ItemType]="Main")

Thanks
DS

 

[Guest]

I assume your DSum is a field on a form ? and your query is not based on the
data on the form ?
Your syntax should be
=DSum("Quantity","MainItemCountQ","[ItemType]='Main'")

 

[DS]

I assume your DSum is a field on a form ? and your query is not based on the
data on the form ?
Your syntax should be
=DSum("Quantity","MainItemCountQ","[ItemType]='Main'")

:

I have a DSum Expression that Im using based on a Query. It works fine
whenever I'm focused on a record that contains the Criteria of "Main",
however when I I'm focused on a record that doesn't have the Criteria of
"Main" my field containing the DSum Expression come up blank. I need
that field to always show the total number of records containing "Main".
How can I accomplish this?

=DSum("Quantity","MainItemCountQ",[ItemType]="Main")

Thanks
DS

Wow!!! That worked! It's amazing what a couple of apostrophes can do!!!!
Thanks
DS