Color formatting

  • Thread starter Thread starter ntc
  • Start date Start date
N

ntc

weeellll, this is posted in the queries area; is your question on how to
develop a query that will return the correct records? or is your question on
how to implement conditional field colors in a report? ....if the latter
you may wish to repost in the Reports area.....
 
I am in payroll and the stupid system that keeps our time will not do a
report that shows who is mssing time or has entered but not submiited or who
has not approved their time. I created a query in Access so that it would
return that information in a calendar view (dates at the top and name down
the side). What I want to do is say that Jane had time from the 16-31st of a
month and some days are not submitted so I want those cells to be a certain
color and if the manager has not approved them they would be another color. I
can not figure out how to get it to do this. I have tried doing a report with
conditional formatting. I have no idea. PLEASE HELP
 
Soc0718,

To use conditional formatting in your report there needs to be a trigger.
What is the trigger that the Manager has not approved the time? What shows
on the report??? (you said cell) that indicates that there is missing days,
is it a blank field?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top