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...

 

[Dreamwalker]

Hmmm

Select column1, column2 from table where column2 > column1

that is quite simple no ... unless I dont understand correctly your question

Vince

 

[dawnd3]

to elaborate on vince's response...bring both fields into your query grid. In the criteria field for the Total_amt field type:

>[Access_amt]

Dawn

http://www.calliopeconsulting.net

 

[rajeessh]

Select <YourFields> from <TableName> where
Total_Amt > Access_Amt

 

[dawnd3]

rajeessh, isn't that what we were saying, or are you saying something different?

http://www.calliopeconsulting.net

 

[rajeessh]

I made the same statement but not of Query Grid Issues
We can form the query in VBA coding itself if necessary
So i gave the query?

 

[suave2damax]

Hi, guys! (&quot;,)

Well, both of you dawnd3 and rajeesh are correct in that both of your suggestions would yield to the same set of records: &quot;record(s) of those who's Total_amt is greater than the Access_amt&quot;. You can either plug the working query or the SQL equivalent of that query as a record source to a report (or even to a form).