Search results

Hey Jon That looks brilliant Hey thanks Jon that looks brilliant, I have done a little changing of the details to match this week, and is working great now thanks. Also i have enter in the criteria "Off" so it doesn't display peole that aren't on annual leave. Thanks for your help.

Date Between Hi MSAccessRookie, The Where statement is coming up with an error. Doe's the "DATE" in "Date between" have any purpose?

I found some information fro a previous thread on here but needed add onto it. The thread in question is "Search between two date fields" by Ross Burrows. I have a Annual Leave Database that im working on and it asks for a Start Date and a End date. (First day off - last day off. I am...