compare then only show different

[James Stout]

Hello kind friends

does anybody know how i can get my database queries to
compare two values and then only show the ones that are
different?


i.e.
currently showing
From To
x312 x476
x514 x514
x398 x556

and want it to show
From To
x312 x476
x398 x556


Many thanks
James

 

[Steve Schapel]

James,

Make a calculated field in your query by typing something like this
into the Field row of a blank column in the query design grid...
Comparison: [From]=[To]
.... and then in the Criteria of this column, put 0.

- Steve Schapel, Microsoft Access MVP