Database Customizing - Current Jobs List

[cwest2k5]

We have a database at my job and we would like to customize it to provide us with a "current" list of jobs we have in house. We want to be able to show this on a wall mounted monitor.
It would need to pull the following info from the database to display on the monitor:



Project Number
Project Name
Client Number
Employee (Employee handling the project)
Start Date
Status (in Progress, On Hold, etc.)
If job is on hold will need a field that can display reason for job on hold
Color Coordinated (Green for 0-7 Days, Yellow for 8-14 Days and Red for 15+ Days

I have attached a pdf of what it could look like.

Is this possible to do?

Thank You

[Mickjav]

It could be done very easily with a db with the screen for your info the monitor would be linked to a pc just use the timer event to update the screen with current data.

I could see a number of ways of doing it.

mick

[ssanfu]

Welcome to the forum....


Sure, it is possible if the data is in the dB. Hard to be more specific without seeing the dB or knowing the design/structure of the tables.
You do have the dB split... right?

Create a query with the required data, create a form using the query and use conditional formatting for the status colors.