Query working to select records before 2012

[Access N0vice]

Help,

I have a query that will give me records between dates as long as the dates I put in are before the year 2012. When a put in date that are from the start of this year the query gives me no records. yes there are records that contain the year 2012. Has anyone else had this problem?

Thanks
Access N0vice

 

[vbaInet]

What is the Data Type of this field?

 

[Access N0vice]

The data type is "date". This query works fine as long as the date is before the year 2012.

 

[vbaInet]

What does it actually say in the Data Type property of that field in the table? "Date" is not a data type in MS Access.

 

[Access N0vice]

Sorry date/time

 

[Access N0vice]

I figured it out it has nothing to do with the date in my query another part of the date base did not get updated with 2012 charge rates so when the query ran there was no data because of the missing rate.

thanks for even replying to my question

 

[vbaInet]

Ok Does it store a Time part as well?

 

[vbaInet]

I figured it out it has nothing to do with the date in my query another part of the date base did not get updated with 2012 charge rates so when the query ran there was no data because of the missing rate.

thanks for even replying to my question

Alright, just saw your post. Glad to hear it's sorted.