Query expression where one field is greater than another

[1starr]

I have two fields in my query , lets call one Access_amt and the other Total_amt, where I only want the query to print out the record of those who's Total_amt is greater than the Access_amt. I have tried a lot of combinations such as creating a subquery with in the query, but nothing seems to work. Do anyone have any I ideas.
Thanks...

 

[mikey69]

One way would be to create a preliminary query with a calculated field Tot-amt and test this for > 0. You might be able to use this as the direct input for your report.

 

[mikevh]

Can't you just say

SELECT Total_amt, Access_amt
FROM YourTableName
WHERE Total_Amt > Access_amt;

or am I missing the point of your question?