Filter report, 1 and 2 won't work, Data Type Mismatch

[flwrgrl]

I am trying to filter my report.

([qry_tbl_Production&item].ProductionDate=#7/13/2011#) AND (ProductionQty>0)

If the ProductionQty is set to a number which would result in the outcome of 1 or 2, I receive an error that the there is a Data Type Mismatch. What is so different about 1 and 2 from any other number?

Thanks!

[boblarson]

Where is this at? Is this in a query? What do you mean by "If the productionQty is set to a number which would result in the outcome of 1 or 2?" I don't understand. What outcome are you talking about here? I don't see anything regarding a 1 or 2?

[flwrgrl]

Sorry, I wrote that right before leaving work, in a hurry.

I am running a report. Using the filter in the report setup, I want to set it to filter for products that have a production of greater than 0 for the day. However, If I set ProductionQty>0, >1, or less than anything (which means it would have to show items that have a 1 or 2 for the day), it gives me the data mismatch error.

[boblarson]

Take a look in the table at the datatype for ProductionQty and tell me what the exact datatype is shown as.

[flwrgrl]

See attached image