M
Mel
Hello,
I am working with Access 2003 and am in desperate need of help.
I am unsure of how to go about this, but I have recently created a database
that allows me to enter data into 3 different ways (by cluster, group and
store). I have select queries for each to break down the groupings to the
the individual records needed (by store). I have then used a union query to
have them all in one place.
From the Union Query, I have a report pulling the information as needed to
display by the individual records (by store). Each of these records has a
ranking column from which I decide the ranking.
Also, each of these stores has 2 specific types of displays (flex and
required) of which both have a set number available for each display type and
store.
I need the report to show both display types, but different requirements for
each display types:
If the display is flex, then I need it to show the records for that store
that are ranked 0 through 15 only.
If the display is required, then I need it to show only the records that are
ranked 0 through the number of required displays that are specified as
available.
I figured the report would be the best place to do this since the breakout
is by store and the quantities and items vary by store.
Any help that can be given is beyond greatly appreciated.
Thanks in advance!
I am working with Access 2003 and am in desperate need of help.
I am unsure of how to go about this, but I have recently created a database
that allows me to enter data into 3 different ways (by cluster, group and
store). I have select queries for each to break down the groupings to the
the individual records needed (by store). I have then used a union query to
have them all in one place.
From the Union Query, I have a report pulling the information as needed to
display by the individual records (by store). Each of these records has a
ranking column from which I decide the ranking.
Also, each of these stores has 2 specific types of displays (flex and
required) of which both have a set number available for each display type and
store.
I need the report to show both display types, but different requirements for
each display types:
If the display is flex, then I need it to show the records for that store
that are ranked 0 through 15 only.
If the display is required, then I need it to show only the records that are
ranked 0 through the number of required displays that are specified as
available.
I figured the report would be the best place to do this since the breakout
is by store and the quantities and items vary by store.
Any help that can be given is beyond greatly appreciated.
Thanks in advance!