Color Coordinating Reports

[mbrande]

I have been teaching myself how to use Access 2000 for about a week now.

I need to produce a color coordinating report that shows out of date training for personnel in my office. I need one color to show a persons classes that are 45 days from being overdue, another color to show a persons classes that are 15 days from being over due, another color showing a persons classes that are 15 days overdue, and another color showing a persons classes that are over 45 days overdue. Does anyone have any idea how to produce this report, and what formula or codes or what ever do I have to use.

 

[geraldcor]

I don't know if this is the cleanest way to do this but I did something similar. I basically made a different query for each possible criteria. I did this based on a date (similar to yours) being either 90 days overdue or 60 etc. So in the date field in your query (or whatever your field is that tells you when someone's classes are overdue) in the criteria set it to Date() <45 or something similar. I don't know exactly how you are judging when classes are overdue so that is just a simple guess. So anyway, Make three queries with the criterias differentiating between the three criterias for classes being overdue. Then you make three reports (or you can make three subreports on a main report but it sounds like you want three reports) each based on a different query you just made and let er rip. I assume you know how to go from here setting up your fields and making the colors you want but if not let me (or some of the more knowlegable members here) know. Sorry if this makes no sense I am writing as fast as my fingers will go before a meeting i have to go to.