making report monthly,yearly and weekly

[myranorkama]

hai.. i'm new at here. can somebody help me. please teach me how to create the report monthly,year and weekly using access 2007??

 

[JHB]

Sorry - I don't think any here will teach you, but we'll help you, if you show what you have reach until now, and explain where you've problems. Please note we are volunteers, not employees!
If you want to get served a runable solution, then I think you have to either hire a programmer or pay for it!

 

[Shuttlekilla]

=TODAY()-30

Thats the base formula I use when trying to get returns that are within 1 month. Try and edit that for your weekly or yearly queries (that are the record sources for reports).

 

[Johnny Drama]

Weekly report: DatePart("ww",[yourdatefield])=DatePart("ww",Date()) and Year ([yourdatefield])=Year(Date())

Monthly report: DatePart("m",[yourdatefield])=x Where x is the numerical value for the month you want

Year to Date: Year([yourdatefield])=Year(Date()) and Month([yourdatefield])<=Month(Date()) and Day([yourdatefield])<=Day(Date())