rocketman70443
New Member
- Joined
- Dec 11, 2010
- Messages
- 37
Data is being pulled from another program into an excel sheet, that is being updated into Access. This sheet contains various product categories. The problem is if a customer has no sales in a particular category, no record is generated.
In access, I have a query that pulls all records belonging to a certain customer. From that query, I have a report that summarizes all the sales to each existing category. Is there any way I can force the categories with no sales to appear?
The only thing I can think of is to have build a table that has each category name in it. But how can I get that table to link to the query & report?
In access, I have a query that pulls all records belonging to a certain customer. From that query, I have a report that summarizes all the sales to each existing category. Is there any way I can force the categories with no sales to appear?
The only thing I can think of is to have build a table that has each category name in it. But how can I get that table to link to the query & report?
