compare then only show different

  • Thread starter Thread starter James Stout
  • Start date Start date
J

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
 
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
 
Back
Top