Problem with Query

[Ramone]

Hello All,

I'm using the IIF statement to return a zero or one
depending on if two dates are equal ( this seems to be
working correctly). When I create a second query that
only give me the records with a 1 from the above query,
the result isn't correct ( to many records are returned).

Can someone tell me what I may be doing wrong?

 

[Ken Snell]

Hard to tell.....you need to post the SQL statements of the two queries so
that we can see what you're trying to do.