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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date header in a report........#Name?

Status
Not open for further replies.

csegal

Technical User
Jun 12, 2001
38
US
I'm having problems with a date header in an earlier version of Access.
The formula that works in Access 2000 is:

=Format$([Cal Due Date],"mmmm yyyy",0,0)

when this database is converted for use on a computer with windows 95 / Access 97 the result is #Name?

I can be reached at
wwhitem@fineair.com
 
Try changing the format statement to this:

=Format([Cal Due Date],"mmmm yyyy")

Joe Miller
joe.miller@flotech.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top