Include All Stores in Query

[Guest]

I have a crosstab query set up to look up stores that have ordered a certain
item with the stores being the rows and the item as the column. I want the
finished product to show all stores regardless if they ordered the product or
not. I have one table with a list of the stores and another table with the
sales information. I have the Join Properties by the store number to
"Include all records from 'Store Table' and only those records from 'Sales
Information Table' where the joined fields are equal". My query appears to
only show the stores that have had some sales activity for that item and does
not include stores that have not. Thought the left to right join I did was
supposed to include all stores from my store table regardless of activity.
Am I missing a step?

 

[Duane Hookom]

I expect since you mention "stores that have ordered a certain item" that
you have filtered out stores. You could create a new query based on your
crosstab and "one table with a list of the stores". Set the join property in
this new query to view all stores.