Color in one cell in a table to shows in Reports

jireland

New member
Local time
Yesterday, 23:14
Joined
May 7, 2012
Messages
3
I know that if I change the font color, the whole table becomes that color. I also know that if I want to change a single cell to a specific color, I can do so in a Form or Report. My problem is that I am using Access as an internal reservation program. I put all our group resercations in a table and then create a report that is handed out to all our point of sales weekly (to let them know what groups are coming in). A lot of things change in one week and I would like to highlight or change the font in one paticular cell...aka if a group has a change in numbers (30 people vs. 20) I would like to make the change and highlight that cell for myself and the ticket sellers (becuase the report goes out weekly).

Pleaseeee help....I've tried everything and can change that cell in a Form but not when Im in the Table and want it to reflect when I print the Report.
 
Thank you Pat.

It sounds like it just won’t work. I think I was hoping that what I altered on my table would reflect on the Report for our ticket sellers/myself/clients. (i.e. add cell color to reflect a change made to the "reservation" and have it correlate to the Report I create)
I can alter the cell color in the Form-conditional formatting and what looks like a one-time change on the Report but because I need it to reflect in what was originally imputed to show a change in the reservation. The table and the report don’t seem to communicate on the cell-coloring level??? I think.

Is it possible that Im not using Access correctly? I make a Table and then a Query with that and THEN generate a Report per week or when a Report is needed to update our Ticket Sellers.
 
Thank you again Pat for your response!

I now understand the "cell" thing but I guess what Im telling you is that Im using Access wrong beucase each "reservation" has a row with is divided into "date of arrival", "time of arrival", etc.

When I tried to manipulate the color in Report, here is where I got to:

See attached.

What should I do next (if anything :o).

j Capture_Access.jpg
 
@girsaum, I will say this once and ONLY once. You DO NOT offer that kind of insults to our members who are trying to help inexperienced members. Pat may or may not take action, but if you insult anyone else and Pat misses it, just be aware that other moderators are on the board too. We will cut your account off cold if you want to take that attitude. This is not some social media board where people can casually toss around insults. We actually have a technical orientation here and our non-tech sections are not our primary business.

If you want to insult people, go somewhere else. 'nuff said.
 

Users who are viewing this thread

Back
Top Bottom