Conditional Formatting a Report based on a query
 

Hi, I have been assingned with the task of building a database for my
company. I need to beable to pull up a report that has information about our
product. This I know how to do. The problem is that the information in the
report needs to be referenced to another set of information. Each set of
information has a unique MS#. I created a query based on a single table that
asks the user for two ms#'s. Then I created a report, but the problem is
that I need to beable to highlight the differences between the two sets of
data. This procedure needs to be automated because there are too many MS#'s
to do this manually, and i don't know how. As well I need to beable to hide
one of the sets of data. So The query would prompt you for two MS#'s but
only show one and use the other as a referance. I am fairly new to access
(using 2003) and I was wondering if this could be done without SQL or VBA,
but if i have to i will those as well. Any help would be greatly appreciated.

Thank you,
Chris Baillargeon

Conditional Formatting a Report based on a query
 

Sorry I meant to post this on the access forums.

"wingfan89" wrote:

Hi, I have been assingned with the task of building a database for my
company. I need to beable to pull up a report that has information about our
product. This I know how to do. The problem is that the information in the
report needs to be referenced to another set of information. Each set of
information has a unique MS#. I created a query based on a single table that
asks the user for two ms#'s. Then I created a report, but the problem is
that I need to beable to highlight the differences between the two sets of
data. This procedure needs to be automated because there are too many MS#'s
to do this manually, and i don't know how. As well I need to beable to hide
one of the sets of data. So The query would prompt you for two MS#'s but
only show one and use the other as a referance. I am fairly new to access
(using 2003) and I was wondering if this could be done without SQL or VBA,
but if i have to i will those as well. Any help would be greatly appreciated.

Thank you,
Chris Baillargeon