I have a table with 5 fields.
I want a query with 1 output field only.
The logic is as follows;
If EnemyYN="Y" and FRIENDYN<>"Y" select SellingPrice1
If FriendYN="Y" then select SellingPrice2
Select sellingprice 3
How do I write this SQL?
(As a tangental question! As a general rule would the experts prefer to receive a sample database attached with queries like this?? Is it more or less hassle to receive an attached database?)