conditional formatting a report based on a query

[wingfan89]

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

 

[Fred]

Hello Chris,

I noticed that nobody answered. If you will forgive the directness in an
attempt to he helpful, in DB terms, your post sort of vaguely hopped all over
a whole bunch of questions, without asking any of them methodically, and
without giving any clear statements of the information that would be needed
to answer them.

My guess is that once you get the above remedied, that this can be done in
Access, without VBA or SQL.

 

[wingfan89]

I appreciate your directness seeing as I am new to this sort of thing, thank
you. As well i a sorry it took me so long to reply i was off work for a
couple of days.
So here it is...
I need to create a report that highlights the differences between two sets
of data that are derived from the same table. I want to highlight the
differences for the data that occurs in the same field.
Ex. Set 1 Set 2
MS 1 2
Ord 15 15
Size 14 16

I created a query for the table so I could prompt the user to select two
specific sets of data, and the report is based off of the query, which is
based off of a table.

I hope that was a little easier to follow. Thanks for the help.