Weekly Sales Report

[Guest]

Hi All,

I came across with this problem. I had several sales order in my table. Now,
I wanna total my sales amount accordingly n produce a weekly report. I had a
form to choose from Jan to Dec. Whenever I choose Jan, I shall be able to
generate a report with Week 1=amount 1(total sales in week 1 only), Week
2=amount 2(total sales in week 2 only), Week 3=amount 3 (total sales in week
3 only) and so on. Anyone can help, please? Thanks!!

 

[John Vinson]

Hi All,

I came across with this problem. I had several sales order in my table. Now,
I wanna total my sales amount accordingly n produce a weekly report. I had a
form to choose from Jan to Dec. Whenever I choose Jan, I shall be able to
generate a report with Week 1=amount 1(total sales in week 1 only), Week
2=amount 2(total sales in week 2 only), Week 3=amount 3 (total sales in week
3 only) and so on. Anyone can help, please? Thanks!!

Create a Query based on your table. In a vacant Field cell type

SaleWeek: DatePart("ww", [SaleDate])

This will return a number from 1 to 54, the weeks in the year. You can
use this as the Column Header in a Crosstab query to get all sales in
the entire year, or more simply just Group By it in a Totals query to
get sales per week.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

Thanks for the reply.

FYI, I will not enter date but month. For instant, I had field from January
to December, not date of each month. So when I choose field "January" on my
form, it will be automatically generate sales from 1 January until 31 January
n divide them into weekly basis like previously I had said. Is that possible,
thanks!!!

Hi All,

I came across with this problem. I had several sales order in my table. Now,
I wanna total my sales amount accordingly n produce a weekly report. I had a
form to choose from Jan to Dec. Whenever I choose Jan, I shall be able to
generate a report with Week 1=amount 1(total sales in week 1 only), Week
2=amount 2(total sales in week 2 only), Week 3=amount 3 (total sales in week
3 only) and so on. Anyone can help, please? Thanks!!

Create a Query based on your table. In a vacant Field cell type

SaleWeek: DatePart("ww", [SaleDate])

This will return a number from 1 to 54, the weeks in the year. You can
use this as the Column Header in a Crosstab query to get all sales in
the entire year, or more simply just Group By it in a Totals query to
get sales per week.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[John Vinson]

Thanks for the reply.

FYI, I will not enter date but month. For instant, I had field from January
to December, not date of each month. So when I choose field "January" on my
form, it will be automatically generate sales from 1 January until 31 January
n divide them into weekly basis like previously I had said. Is that possible,
thanks!!!

I do not understand. What is actually stored in your table? Do you
want just four (or five, depending on the month) rows in the result?

Please post a sample of your current table contents, for some month
OTHER than January - just two or three rows - and an example of what
you want the output to look like.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

Thanks.

I had a table as below.
SalesDate: 11/1/2004, 11/2/2004, 11/23/2004, 12/1/2004, 12/2/2004
SalesAmount: $10, $5, $3, $18, $7

FYI, the sales are according to the date respectively. For example,
11/1/2004 is $10 and 11/2/2004 is $5. I can't draw it out, sorry.

Ok now I had a menu with combo box choosing from January, February, March
and so on. When I choose November in the combo box and click Search, I will
get a report like below:

Sales for November: Week 1=$15, Week 2=N/A, Week 3=N/A, Week 4=$3, Week 5=N/A

If I choose again in combo box for December, my report will generate me
result:

Sales for December: Week 1=$25, Week 2=N/A, Week 3=N/A, Week 4=N/A, Week 5=N/A

Thanks a lot!!