Date formatting issue Access 2003

[Akaisar]

Hello,

I am having an issue where I am trying to make a date in a certain field not contain the weekday. I am running a query and I will need to select from a period of time from 1/1/08-12/31/09. I am wondering how I can remove the weekday from the date. The format for long date currently is Sunday, June 19, 1994. I need it to read June 19, 1994 and store the information that way in the database so I can mail merge to a word document, unless there is a better way to put this information in a document, maybe a form.

Thank you in advance for any help.

 

[pbaldy]

As long as it's a date/time field, you don't need to worry about how it's formatted in the table. It is always stored as a double, and a query criteria of 1/1/08-12/31/09 should get the records. You can use the Format() function to format the date the way you want in a query. You can usually achieve what you want in a report without having to push data out to Word.

 

[Akaisar]

Thank you I will give that a try. I also just found some information on parameter query's that I am going to look into. Apparently you can have the Query prompt you for the two dates to be inbetween.

 

[pbaldy]

Absolutely, and most of use forms to gather input from the users instead of the query prompt.