Printing out just Month and Year for a report (1 Viewer)

mtp

Registered User.
Local time
Today, 08:34
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
 

rwpetrie

Registered User.
Local time
Today, 08:34
Joined
Dec 12, 2000
Messages
25
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
 

Fornatian

Dim Person
Local time
Today, 08:34
Joined
Sep 1, 2000
Messages
1,396
Are you taking about the print date?
 

mtp

Registered User.
Local time
Today, 08:34
Joined
Dec 8, 2000
Messages
35
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.
 

mtp

Registered User.
Local time
Today, 08:34
Joined
Dec 8, 2000
Messages
35
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.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 03:34
Joined
Feb 19, 2002
Messages
43,328
Assuming you want to print the current month and year, place the following in the controlsource:

= Format(Date(),"mm/yy")
 

mtp

Registered User.
Local time
Today, 08:34
Joined
Dec 8, 2000
Messages
35
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

Top Bottom