Recent content by DodgeyAus

G'day Isskint & arnelgp, Tried both of those. As it turns out, after playing with both suggestions, it was the sequence in which I had the formatting. Moving ""≤5" above "N/A" resolved the issue. Thanks for your time. Cheers, Rog

G'day. I've imported data from a spreadsheet, and one of the field values is "≤5". The other possible values are 6, 7, 8, 9 and N/A. The report is quite happy to format the cells for them, but refuses to do anything for ≤5. I've tried changing the data in the source spreadsheet to "<=5" and...

Thanks guys. Looks like I need to learn another "language". Been suspecting that for a while, but haven't had the time. Need to move it up the list!

G'day I currently have 3 copies of the same report, all based on similar queries: One which prints all reports. One which prints the reports based on the teacher entering their name (which is an expression in the query & report) One which prints the reports based on the teachers entering...

Been using Access for a fair time, but self-taught ... which obviously includes picking other people's brains and doing a lot of "Googling". :) My current "project" is a reporting database for the school where I teach, which taps into 3 other databases, and spits out reports that meet our...