Control Source for reports

[gfcjr]

I want to add a month Only on a monthly report, with out having to type it for each report. It wold be nice that it would change automatically each month. example May June July etc..

 

[KevinM]

Not quite sure what you want?

Is it a parameter where the user simply types in a month and the report opens on that input only or print the current month or something else?

 

[gfcjr]

on the Control source in a form, when you want to add the present date you would do this =date() and that would give you a fill in date for that day. I would like to do that with just a month like =month() but that don't work, it's say's something about wrong expression. Understand?

 

[KevinM]

If you want to dispaly the current month only then there are several ways to do this.

=Month(Date())

=Format(Date(),"mmm")

=DatePart("m",Date())

HTH

 

[gfcjr]

Thanks Kevin you where very helpful