Conditional query?

polgara

Registered User.
Local time
Today, 05:49
Joined
Feb 22, 2001
Messages
11
Yet more help required.

I've got a table thats used for tracking documents, with the following fields

Organisation, QF_received, QF_checked, QF_imported, QS_received, QS_checked, QS_imported etc.

I need to be able to run a report that will list all the organisations and then under each document title show a coloured cell- eg

QF
RED (not received)
Blue (received, not checked, not imported)
Yellow (received, checked, not imported)
Green (received, checked, imported)
 

Users who are viewing this thread

Back
Top Bottom