I have report that list a lot of items with a cost value. The report runs fine and gives me a list of items in stock with cost and in the table there is a Sold (yes/no) box.
I placed a text box on the report to give me a cost summary of all items, but I want to capture the cost minus the sold items and still show the Yes/No box on the report.
If I type in false on the criteria field in the query I get the correct value on the report but I can't show the Yes/No box with or without check marks.
Can't figure this one out, any ideas?
Jim