Hello,
I am writing a query to seperate only the records with '<>ok' in any one or more of the columns. I have so far written a staircase shaped query in the design view that looks like this:
<>ok
<>ok
<>ok
and on and on!
with each line having one column with the condition in it. Is there a simpler way (I am quite prepared to attempt SQL, but have not done much so be gentle!).
I would be very greatful for any help.
Thanks
SO
By the way....
What I am trying to do (probably going around it the long way) is compare two similar tables of about 30 columns and highlight differences between them in any of the catagories. Linked by a Key field I am using an iif to either display 'ok' if the two tables are a match for this record and catagory or I am presenting the two entries seperated by a rather artistic "<==>" (Right <==> Write) so I can scan the results and investigate the mismatch problems without having to look in other tables. I then need to filter leaving just the not OK records hence the above. Its not pretty but it is just a tool I need to use quickly as soon as i am asked. Is there a better way to do this? I have evolved this method from Excel so it may be missing a bit of access finesse.
I am writing a query to seperate only the records with '<>ok' in any one or more of the columns. I have so far written a staircase shaped query in the design view that looks like this:
<>ok
<>ok
<>ok
and on and on!
with each line having one column with the condition in it. Is there a simpler way (I am quite prepared to attempt SQL, but have not done much so be gentle!).
I would be very greatful for any help.
Thanks
SO
By the way....
What I am trying to do (probably going around it the long way) is compare two similar tables of about 30 columns and highlight differences between them in any of the catagories. Linked by a Key field I am using an iif to either display 'ok' if the two tables are a match for this record and catagory or I am presenting the two entries seperated by a rather artistic "<==>" (Right <==> Write) so I can scan the results and investigate the mismatch problems without having to look in other tables. I then need to filter leaving just the not OK records hence the above. Its not pretty but it is just a tool I need to use quickly as soon as i am asked. Is there a better way to do this? I have evolved this method from Excel so it may be missing a bit of access finesse.