View Full Version : Control Source for reports


gfcjr
05-08-2001, 01:16 PM
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
05-08-2001, 02:36 PM
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
05-08-2001, 09:06 PM
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
05-09-2001, 02:53 AM
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
05-09-2001, 07:58 PM
Thanks Kevin you where very helpful