Query Help 1

[jalenben1]

I have a query in Access and I need help on a formula. I have a feild called DateCreated and I would like to create a formula in the query with a fieldname called Week Beginning in which the beginning of the week would start off as 1/1/2011 based off the DateCreated fieldname; next create a formula in the query with a fieldname called Week Ending in which the ending of the week would end on 1/7/2011 based off the DateCreated fieldname. So I would have a fieldname called Week Beginning and Week Ending. The last field name I would like to create is Month. This would be based off of the Restoral Date. Let's say a restoral date is 1/31/2011; I would like to have a formula that would take the "mm" to say January. In this case 1/31/2011 the "MM" is 1 which would be January. So that makes it 3 field names I would need help to create in my existing query.

 

[dhookom]

jalenben1,
Search Help on Date Functions. You will find almost everything you need like DateAdd, WeekDay, etc.

Duane
Hook'D on Access
MS Access MVP

 

[jalenben1]

I am thinking that I can format the date to show in the format mm/dd/yyyy in the textbox in a form. Eventually from the query I will used those two date fileds in a form. Am I on the right track?

 

[dhookom]

If you want to display the date portion then you can use the Format property of your control.

Duane
Hook'D on Access
MS Access MVP