In the "Type" column of this report should be for example "Absence" but in one of them its showing 12 which is the ID number corresponding to the data entered. Not sure why on record is different from the rest. Access 2007
Novice
Windows 7 32bit 
Access 2010 32bit
In the "Type" column of this report should be for example "Absence" but in one of them its showing 12 which is the ID number corresponding to the data entered. Not sure why on record is different from the rest. Access 2007
Moderator
Windows XP Access 2003
Are you using lookup fields with tables? How is your field "Type" defined?
Can you show us your tables and relationships (jpg of relationships window)?
Changing data format on ad-hoc basis in reporting
Posting Permissions
Reply With Quote