Printing out just Month and Year for a report

mtp

Registered User.
Local time
Today, 17:35
Joined
Dec 8, 2000
Messages
35
I'm working on a report, and I just want to print out only the month and year for that report (i.e. 12/00) . Is there any way to do that? Please help
 
Base the report on a query, and set the criteria for the date as (Like "*" & [Enter Date] & "*") without using the paranthesis I put in. When it opens, it will only show the records associated with that date
 
Are you taking about the print date?
 
I want to put it in a text box (unbound) so when I print the report it will show the month and year. Is that possible? because I don't see any format for just month and year without the date print out.
 
I want to put it in a text box (unbound) (report's design) so when I print the report it will show the month and year. Is that possible? because I don't see any format for just month and year without the date print out.
 
Assuming you want to print the current month and year, place the following in the controlsource:

= Format(Date(),"mm/yy")
 
It's worked!!!
Thank you rwpetrie, Fornatian and especially Pat. Thank you so much for all your helps.
I love this page!
 

Users who are viewing this thread

Back
Top Bottom