Month and day Summaries

[SDS100UK]

I have a table with the number of products sold by day in it.

I have queried it to give me a total of products sold by day. I have another query with the same fields but that gives me the total of products sold by month.

I need to be able to see the product with the daily total and the monthly total next to it so I can work out the daily percentage of the monthly total.

Can this be done?

Many thanks

Steven

 

[wemeier]

Steven,

You could write a third query that joins the first two queries together by the date (on the daily query) and month (on the monthly query). For example:

FROM DailyTable INNER JOIN MonthlyTable ON DatePart("mmmm",DailyTable.Date) = DatePart("mmmm",MonthlyTable.Date)

What this does is say "if the name of the month that the daily date falls in matches the name of the month that the monthly date falls in, join them together."