I have a form which displays the results of a search on a table which holds records on all changes made to any employee record in the database.
Searching is done by entering an employee Id, or an employee id and a date.
If I enter just the employee id I get all the changes that have occurred returned.
Now heres the strange bit, if I enter an id and a date from March (ie 20/03/2000) it returns all changes on that date correctly for the particular employee, but if I enter a date from April (ie 06/04/2000) then no records are returned when there should be.

Anybody out there have any ideas at all?