Filtering values in a query

B

Biederboat

I have a calculated value in a query, and I want to filter out negative
numbers. In the criteria field for that field, I've tried everything from ">
0" (with and without quotation marks, etc.), all kinds of things and
everytime I run the query I get a dialog box that prompts me for a value.
Can someone help me here? I've even tried putting the field name in brackets
in front of the expression.

Thanks,
Biederboat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking up a value in a query 1
Linking a query value to a table 1
FILTERING -- ACCESS 2010 23
Parameter Query With Null Values 3
Help! on filtering a report using a form & query 7
Filtering a table does not work 5
invalid vertical bar 2
Where to put an IIF in a query 2

Top