J
Jessica
Hello All,
I've created a database using Access 2003 and converted it to Access 97
to use at work but there are acouple of fields in my report that when
previewed the report shows Name? and #Name? for the following two
procedures. Does anyone know why it would show the fields in the reports
that way. FYI I then opened the reports both in 97 and 2003 format when
I got home and the reports displayed every field fine.
=IIf(IsDate("#2/29/" & Year(Date()) &
"#"),Format(DatePart("y",Date()),"000")+400 &
Right(Format(Date(),"yy"),1),IIf(Date()>=DateSerial(Year(Date()),3,1),Format(DatePart("y",Date())+1,"000")+400
& Right(Format(Date(),"yy"),1),Format(DatePart("y",Date()),"000")+400 &
Right(Format(Date(),"yy"),1)))
and
=Time()
Thanks,
David
I've created a database using Access 2003 and converted it to Access 97
to use at work but there are acouple of fields in my report that when
previewed the report shows Name? and #Name? for the following two
procedures. Does anyone know why it would show the fields in the reports
that way. FYI I then opened the reports both in 97 and 2003 format when
I got home and the reports displayed every field fine.
=IIf(IsDate("#2/29/" & Year(Date()) &
"#"),Format(DatePart("y",Date()),"000")+400 &
Right(Format(Date(),"yy"),1),IIf(Date()>=DateSerial(Year(Date()),3,1),Format(DatePart("y",Date())+1,"000")+400
& Right(Format(Date(),"yy"),1),Format(DatePart("y",Date()),"000")+400 &
Right(Format(Date(),"yy"),1)))
and
=Time()
Thanks,
David