My Grocery Store Records

B

Beverly

HI! Hope Someone Can Help A Beginner

Have Three Tables:
Sales: SalesDetal:
SalesCategory:
SalesID SalesDetailID CategoryName
SalesCategoryID CategorySales
SalesEndingDate
WeeklySales
WeeklyPurchases
SalesDetailID

I am trying to create a report that shows the category
percentages of total weekly sales. Having trouble. I am
attempting to create a recordsource for the report using
the three tables. Relationships are as follows: Sales
Table on the one-side and SalesDetail on the-many side
where one sales can have many sales details. My Problem is
that the recordsource Query Show the The Weekly Sales for
every category sale
Record Ex:
Ending Date Weekly Sales Category Category
Sales
11/21/03 10000.00 Grocery 6500.00
11/21/03 10000.00 Produce 1500.00
11/21/03 10000.00 Dairy 2000.00
11/28/03 11000.00 Grocery 7000.00
11/28/03 11000.00 Produce 2500.00
11/28/03 11000.00 Dairy 1500.00
And My Report Won't Total The Weekly Sales Correctly.
WHAT AM I DOING WRONG???

Thanks
Beverly
 
Top