I know the title here is going to make some people think I've lost my mind before the thread even begins. Let me lay out the context.<BR><BR>I do some consulting work for my former employer because ...

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 ...