comparing two columns

[vasu1211]

There are two columns in my table and the corresponding report- Transport amount and Updated amount

I want to see only those rows or records where transport amount is greater than updated amount.

I tried using a query setting criteria to [transport amount]> [ sunrate amount]

but this is not working

Any help either in access or excel

thanks

 

[dhookom]

You should be able to set the criteria under [transport amount] to

> [sunrate amount]

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]