K
Kevin Labore
Hi
I need help with a form to input information in weekly format (Sun - Sat)
The data I would be inputting for each record is Sales $, and Sales QTY for
each dept #
Depending on the business day I have from about 45-50 departments for each
day
Here is an example of what I would like the table input to look like, I
believe I would need Form,Subform --- Other Suggestions?
I want to be able to enter the week ending date and open the form to be able
to input data for the entire week at once
Sun 10/31 Mon 11/1 Tue 11/2 Wed 11/3 Thu 11/4 Fri 11/5 Sat 11/6 Total
11/6/04
Week # Dept # Dept Sales Sales Sales Sales Sales
Sales Sales Total
Desc Sales $ QTY Sales $ QTY Sales $ QTY Sales $ QTY
Sales $ QTY Sales $ QTY Sales $ QTY Total $ QTY
1 1 Dept 1 $100.00 7 $200.00 5
1 2 Dept 2 $700.00 500 $1,000.00 600
1 3 Dept 3
1 4 Dept 4
1 5 Dept 5
1 6 Dept 6
1 7 Dept 7
1 8 Dept 8
1 9 Dept 9
1 10 Dept 10
1 11 Dept 11
1 12 Dept 12
1 13 Dept 13
Note: this doesn't show actual data and I only filled in 2 departments, DOWs
to show example and normally about 45-50 rows(departments)
Below is desc of tables
DEPTS (Table) : DeptID, DeptNum, DeptDesc, DeptStatus(Active or InActive)
DeptSales (Table): DeptSalesID, DeptRecID, DeptNum, DeptSales, DeptSalesQTY
DeptDate (Table): DeptDateRec, DeptDate
Can someone tell me to go about getting the result I want? I prefer to use
the form design rather than VBA
Also if someone can tell me where I can find an example of how this can be
done would be helpful
Presently I use a form/subform. Enter/Select the day(date ie. 11/01/04)
then the Subform ask for Dept#, sales $, Sales qty for each inpt row) and
then change the date when all rows entered. This is tedious (also there no
way to get the data between the 2 computer systems) so I need to use the
print out from one system and enter that data so I can track and create
reports with it.
Thanks for any assistance that you can provide --- if you need further info
to help provide a answer let me know.
Kevin
I need help with a form to input information in weekly format (Sun - Sat)
The data I would be inputting for each record is Sales $, and Sales QTY for
each dept #
Depending on the business day I have from about 45-50 departments for each
day
Here is an example of what I would like the table input to look like, I
believe I would need Form,Subform --- Other Suggestions?
I want to be able to enter the week ending date and open the form to be able
to input data for the entire week at once
Sun 10/31 Mon 11/1 Tue 11/2 Wed 11/3 Thu 11/4 Fri 11/5 Sat 11/6 Total
11/6/04
Week # Dept # Dept Sales Sales Sales Sales Sales
Sales Sales Total
Desc Sales $ QTY Sales $ QTY Sales $ QTY Sales $ QTY
Sales $ QTY Sales $ QTY Sales $ QTY Total $ QTY
1 1 Dept 1 $100.00 7 $200.00 5
1 2 Dept 2 $700.00 500 $1,000.00 600
1 3 Dept 3
1 4 Dept 4
1 5 Dept 5
1 6 Dept 6
1 7 Dept 7
1 8 Dept 8
1 9 Dept 9
1 10 Dept 10
1 11 Dept 11
1 12 Dept 12
1 13 Dept 13
Note: this doesn't show actual data and I only filled in 2 departments, DOWs
to show example and normally about 45-50 rows(departments)
Below is desc of tables
DEPTS (Table) : DeptID, DeptNum, DeptDesc, DeptStatus(Active or InActive)
DeptSales (Table): DeptSalesID, DeptRecID, DeptNum, DeptSales, DeptSalesQTY
DeptDate (Table): DeptDateRec, DeptDate
Can someone tell me to go about getting the result I want? I prefer to use
the form design rather than VBA
Also if someone can tell me where I can find an example of how this can be
done would be helpful
Presently I use a form/subform. Enter/Select the day(date ie. 11/01/04)
then the Subform ask for Dept#, sales $, Sales qty for each inpt row) and
then change the date when all rows entered. This is tedious (also there no
way to get the data between the 2 computer systems) so I need to use the
print out from one system and enter that data so I can track and create
reports with it.
Thanks for any assistance that you can provide --- if you need further info
to help provide a answer let me know.
Kevin