Comparing two fields

[Roper7]

I need to run a query that will compare the values of two fields, but I can't figure out how to work this. Basically what I want to do is this: I have two numeric fields, COB and Normal Benefit. If the amount in the Normal field is equal to or less than the amount in the COB field, I want to pull those records. What's the best way to do this? Lee

 

[THoey]

Try:

SELECT *
FROM MyTable
WHERE MyTable.Normal <= MyTable.COB Terry M. Hoey

 

[Databaseguy]

Include both fields in your query.

In the criteria for the Normal field, enter

>=[COB] Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy