1- How can I compare various dates in Access query. For example, I have a
"purchase date", "sold date", with which i want to compare with a "start
date" and "end date". The date format is dd/mm/yy. Can this comparison be
done in 1 condition; i.e start date purchase date end date,..
2- Can date comparison be put in an IIF statement in a query, because i
always get #error when I use it.
Thanks