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
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