Query to use in Automation

[belsha]

I have a query that calculates 18 mos. from a date and is formatted like 6/2004. Another field that calculates 2 years from the date exactly like 6/15/2004. It's your typical calculated field Letter: DateAdd("m",18,[CourDt]). Question 1 is why can't I put in a criteria like >6/2004 and get a result?

 

[jeremie_ingram]

If this is a date filed you have to enclose the critera in octets.

>#6/2004#

 

[dcx693]

6/2004 is not a recognized date format in Access. When you attempt to put it into your criteria, Access should automatically change it to 6/1/2004.

 

[belsha]

Query problem

I did enclose it, and after reading your comments, I decided to change the format back to include the date, and change the way I was going about it to use a parameter query instead of just looking for things in a format like 4/2004. Thanks!