Recent content by emf
-
E
QBF Multiple criteria And, Or, IIF?
Thank you again Sensetech, The Nz didn't work for me but you got me on the right path. I wound up useing a IIf exp with a IsNull exp. I had tried it before but I was useing "*" instead of dates & numbers. It works great now. This is what it looks like: WHERE ((([CD LOG].CD_NO) Between... -
E
QBF Multiple criteria And, Or, IIF?
I can try it until at least Friday, but i wanted to say thank you. -
E
QBF Multiple criteria And, Or, IIF?
Hello and thank you in advance, I've never posted anything so I'm sorry if I etquette is incorrect. I've got my table set (haha) as well as a query form, and a basic select query. I've got 8 fields in my select query and on my query form. When I set up the criteria as "And" I have to enter...