Data not returned in a Query from an MS table linked to SQL Server

[Ranvier]

Hello,

I have a Microsoft Access database table that links to an SQL Server database table. I have created an access query that retrieves the fields from the table. For some particular records they are not being shown in the query. For example I have tested this on one particular record and it is present in the SQL Server table and present in the Access table but the query returns nothing. I think it is something to do with one field in particular and this is a DATE field because when I run the query it brings back 1 line but all the fields are blank. It's as if the query knows the row is there but is not displaying it and is determined on the date field (if I omit the date field the query will not even display a blank line). I have compared these date values of the date field with other records that are returned in my query and they are in the same format.

Any ideas of what is going on here?

Thanks

 

[PWise]

what is the date format id SqlServer
what dilimiters are you using in access

 

[Ranvier]

SQL Server
System Type: datetime
Example Date: 2011-02-23 00:00:00.000


Microsoft Access
Field Type: Date/Time
Example Date: 23//02/2011

Thanks