Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Showing only current month on the Report Header

Status
Not open for further replies.
Valeriya

Valeriya

MIS
Jan 9, 2006
138
US
Hi Guys,

I have a text box added to the report header that suppose to show ONLY a cuurent month in words (February,March...). How can I modify the following function:

=Format(Date(),"m")

Thanks a lot!

Valeriya

 
Sort by date Sort by votes
=Format(Date(),"mmmm")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
816
dhookom
dhookom
lameid
  • Locked
  • Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
601
lameid
lameid
YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
231
dhookom
dhookom
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
508
PizMac
PizMac
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
2K
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top