Database help

mbrande

New member
Local time
Yesterday, 23:58
Joined
May 10, 2006
Messages
7
Hello,

I basically started teaching myself how to use Access 2000 about a week ago. I am working on a project for work, that requires to have a report of all the training records. But my boss wants it to be color coded. He wants one color to show the people's training classes that are 45 days out from being over due, he wants another color to show what classes are due. And another color that shows classes that are over due. In my table, I have a column for the classes that show the date that they took the class, and I have another column that shows the due date of the class. But I have no idea how to go about getting the report color coded with what he wants. Any help at all would be great. Many thanks in advance.
 
When in the reports design veiw click on the textbox you want colored on go to Format/Conditonal Formatting.
 
When in the reports design veiw click on the textbox you want colored on go to Format/Conditonal Formatting.
 
When in the reports design veiw click on the textbox you want colored on go to Format/Conditonal Formatting.
 
Search for "Conditional Formatting".

Also, please delete all the other "duplicate" postings you made. Open each one with the "edit" button and then click the "delete" post button within each duplicate.
 

Users who are viewing this thread

Back
Top Bottom