Conditional Formatting

[assassin4213]

Hello Everyone,

Ok here's the scoop. I have a report that is generated by sorting all the shipments received for each vendor per quarter. Each vendor has their own unique specifications, which are entered and stored on a vendor table.

My goal is to be able to automatically highlight in red samples that are out of specification for each vendor on the report. The problem that I run into is that vendors are always being added or removed and specs are different for each vendor. This dynamic has created some challenges for me in regards to the conditional formatting. Would anyone have some thoughts on how to accomplish this?

Talk to ya' later,

Greg

 

[joeselch]

If you aren't already, you should be storing the specs for each vendor in a table. (I don't know your DB's structure, so I can't tell you which table!)

Ensure that the query upon which your report is based includes this specs field.

Then, set up your conditional formating to compare the sample values to the specs field.

 

[assassin4213]

Separate Tables

If you aren't already, you should be storing the specs for each vendor in a table. (I don't know your DB's structure, so I can't tell you which table!)

I have two tables setup. One for samples that have a selected vendor for each sample. One for vendor information. How can I combine these two tables into a select query?

 

[assassin4213]

Never Mind

Thanks for your help. I actually just figured things out. I was never aware of how to make normal inner joins with a query. I now know and knowing is half the battle.