M
Mel
I have created a database that has several tables and relationships. I am
needing to have the report do a, for lack of a better term, a complex if then
statement.
Basically, I need it to be based from below:
Field - Display Status - 2 different status (required/flex)
Field - Display Location Type - 3 different types (endcap/sidecap/wood box)
6 Fields - All basically the same, but based on store #, field name = # of
required/flex endcap/sidecap/wood box - All fixed
I need it to show all fields specified on the report (which is seperated by
store so I can dump the report onto out intranet to allow only each store to
see their individual report later) but by ranking. The table this report is
pulling from has the ranking defined. Each store has a set # of
required/flex endcap/sidecap/wood boxes. However, because there are more
items than each store can support; hence the need for ranking. So basically,
based on display status and location type, if the # of required/flex
endcap/sidecap/wood box is greater than the total # of items in the table for
that store, then display all items, Else if the # of required/flex
endcap/sidecap/wood box is less than the total # of items in the table for
that store, then only show the items that the ranking = 1 up to the # of
required/flex endcap/sidecap/wood box.
I have no idea how to get this done and have tried many failed attempts. I
haven't programmed in years so I consider myself a complete idiot for
programming at this point.
Any help that I can get on this is beyond greatly appreciated.
Thank you so much!
needing to have the report do a, for lack of a better term, a complex if then
statement.
Basically, I need it to be based from below:
Field - Display Status - 2 different status (required/flex)
Field - Display Location Type - 3 different types (endcap/sidecap/wood box)
6 Fields - All basically the same, but based on store #, field name = # of
required/flex endcap/sidecap/wood box - All fixed
I need it to show all fields specified on the report (which is seperated by
store so I can dump the report onto out intranet to allow only each store to
see their individual report later) but by ranking. The table this report is
pulling from has the ranking defined. Each store has a set # of
required/flex endcap/sidecap/wood boxes. However, because there are more
items than each store can support; hence the need for ranking. So basically,
based on display status and location type, if the # of required/flex
endcap/sidecap/wood box is greater than the total # of items in the table for
that store, then display all items, Else if the # of required/flex
endcap/sidecap/wood box is less than the total # of items in the table for
that store, then only show the items that the ranking = 1 up to the # of
required/flex endcap/sidecap/wood box.
I have no idea how to get this done and have tried many failed attempts. I
haven't programmed in years so I consider myself a complete idiot for
programming at this point.
Any help that I can get on this is beyond greatly appreciated.
Thank you so much!