Hi All
Is there something I can write in to a query which will tell me whether the 1 April 2006 appears in between two dates (which are entered by a user?)
For example, if they put the first date (which is one field) as 25/3/06 and then they put the end date (which is another field) as 4/4/06 - I just want the query to produce the word "yes"?
Thanks
Maria
Is there something I can write in to a query which will tell me whether the 1 April 2006 appears in between two dates (which are entered by a user?)
For example, if they put the first date (which is one field) as 25/3/06 and then they put the end date (which is another field) as 4/4/06 - I just want the query to produce the word "yes"?
Thanks
Maria