I was trying to write a conditional query in MS Access today, without success. Here's the problem.<BR><BR>I have a field (myField) that is a lookup to a table (myTable) in the query. myField stores ...