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)
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)