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..
|
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 |