S
Supe
I have a table that has all the sales by store for multiple items. I have
linked this to my store list using a left to right join properties. I have a
report set up that has the item listed in the page header and then the stores
that ordered that item in the store number footer. The report shows any
store that ordered that item. Is there a way to list the stores that did not
order the item? For example, there is a total of 36 stores and 28 ordered
this item so they appear on my report. I want to have a report that shows
the 8 that did not order this specific item. Have mulitple items so each
page would only show the stores that did not order each item. If I enter "Is
Null" in the order column of the Query, it only brings up stores that did not
order any items at all.
linked this to my store list using a left to right join properties. I have a
report set up that has the item listed in the page header and then the stores
that ordered that item in the store number footer. The report shows any
store that ordered that item. Is there a way to list the stores that did not
order the item? For example, there is a total of 36 stores and 28 ordered
this item so they appear on my report. I want to have a report that shows
the 8 that did not order this specific item. Have mulitple items so each
page would only show the stores that did not order each item. If I enter "Is
Null" in the order column of the Query, it only brings up stores that did not
order any items at all.