I am trying to reduce the data selection for users. For one user I wish to select all data
WHERE FIELDA = 'Y' OR
(FIELDA = 'N' AND FIELDB = 'Y').
So this is two different selections based on two different fields. As far as I can see, I can only do reduced data selection on one field. Is this correct ? If this is the case I'm wondering whether concatenating FIELDA and FIELDB is the way forward.
Can anybody offer advice on this ? It's driving me up the wall and down again....
