Problems after Update Query

[Neil_Pattison]

I have a problem with a database I'm maintaining after I have carried out an update query.

I have a macro that imports data from an excel spreadsheet onto a temporary table, which then runs the update query to my main table.

This all works fine and the data is updated correctly.

The problem occurs when someone tries to carry out a search on the date fields in the main table (i.e. it comes up with no results).

I know the queries that run the searches on said date fields are all correct as, if the data is manually typed in, they all work fine.

I thought it may have been something to do with the formats of the data coming in from excel but they are all the same (dd/mm/yyyy).

Does anyone have any idea why I'm having this problem?

Any help would be greatly appreciated.

 

[JHB]

Take a screenshot of the data in the table and show you query.
Else post the database with some sample data in.

 

[Neil_Pattison]

Thanks for your reply, however I have now sorted this.

I thought the issue was more complicated than it actually was. The issue was actually in the source data coming from the excel spreadsheet, so my database was working correctly all the time.