Select Query - Show field that is greater than differnet field

[Guest]

Hello all,

Here is my problem. I have 2 columns both with numbers in them. I am trying
to use a select query to only see the records in one column that a greater
than the number in the second column. So I have:

Avg Days Days Placed
5 4
2 5
8 3

I want to see...

Avg Days Days Placed
5 4
8 3


My query reads..

Field: Avg Days
Table: Master
Criteria: >= [master].[days placed]

There are other fields on the table let me know if you need to know what
they are. When I run this query not only does it show pretty much everything
it also shows the data for days placed in another column that houses
different data (its the column next to it). that is the only criteria that I
am using for the query.

Thank you for any assistance that you can offer, it is greatly appreciated.

James O

 

[Wayne Morgan]

I tried what you appear to have and it worked ok.

1) Please post the SQL view of your query.

2) What is the Data Type of the fields [Avg Days] and [Days Placed] in the
table [Master]? You will need to open the table in design view to find this.