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!

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

Reports: Date Formatting 1

Status
Not open for further replies.

XMalvolio

IS-IT--Management
Apr 5, 2005
14
0
0
US
I want a report to display only the year of my [Contract Date] field from the table [JobData]. I've read all the help files Access 2003 provides and I've tried a thousand things that don't work. What works?

And if you give me code to enter, please tell me in which field it should be entered. I still don't have my Access sea legs.
 
Did you try entering yyyy in the format property of the control?

Roy-Vidar
 
Seriously, that's amazing thank you. I can't believe after all I read and searched nothing in the Microsoft help mentions this. Or I'm blind. Either way, thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top