I have a query which has 2 fields (among others). The fields are NumStraws and Shipped. The Numstraws field simply displays the number of straws entered for that SampleID. The Shipped field counts the number of shipped straws for that SampleID. Shipped is a check box. It works right now, Numstraws shows the correct number and Shipped shows the correct number. What I want the query to do is only display those SampleID records where Numstraws is greater than the count of Shipped.
In the Total category for Shipped I have count selected. I thought using a Citeria in the Numstraws field, such as >[CountofShipped], would work. CountofShipped is listed as a variable when you try to build a criteria for NumStraws. When I did this, the query now asks me for the value of CountofShipped instead of calculating it from the data.
What am I doing wrong?
In the Total category for Shipped I have count selected. I thought using a Citeria in the Numstraws field, such as >[CountofShipped], would work. CountofShipped is listed as a variable when you try to build a criteria for NumStraws. When I did this, the query now asks me for the value of CountofShipped instead of calculating it from the data.
What am I doing wrong?