Date Criteria

[gissah]

Is there a way I can set a criteria in a report to give me "this month entry " anytime I run my query without typing the month in my criteria.
instead of "January" in the criteria query box, may be use a parameter in a form or CmdBtn

 

[honda882000]

I think this will answer your questions:
http://office.microsoft.com/en-us/access/HA011170771033.aspx

 

[WIS]

Is there a way I can set a criteria in a report to give me "this month entry " anytime I run my query without typing the month in my criteria.
instead of "January" in the criteria query box, may be use a parameter in a form or CmdBtn

If by "this month entry " you mean the current month, try Month(Date()) And Year(Date()) in the qry criteria cell.

 

[gissah]

Thanks everyone honda882000 link was very helpful