dsum in textbox problem

[rockiwood]

I used the following in a text box as a report footer. Actually I have a few of these with different "Categories"

=DSum("[HoursWorked]","[qryOvertime]","[Category] = Type 1' AND [fldFullPart]='Part' ")

During setup and testing, the calculations worked great. Now that the database is in use, the textboxes just show up blank. I'm pretty sure the DSum format is correct. I have compacted and repaired the database and imported to a new blank database and still blank boxes.

Any suggestions would be much appreciated.

Jerry

 

[rockiwood]

Stupid Mistake..

I found the problem. When one changes their own titles, one should, at the very least, REMEMBER THIS!!!!!!

Thank you for your attention. In case anyone read it.


Jerry