K
KimTong via AccessMonster.com
Dear all,
Can we use a lay out input like Pivot table and then we can save it in
regular table?
Sample for layout Input:
2/1/08 2/2/08 2/3/08 2/4/08
NY 25 10 10 5
NJ 15 8 5 5
CT 20 12 11 8
When the user enter that chart, Acces should save it in regular Table that
has 12 records like this:
State Date Amt
NY 2/1/08 25
NY 2/2/08 10
NY 2/3/08 10
NY 2/4/08 5
NJ 2/1/08 15
NJ 2/2/08 8
NJ 2/3/08 5
NJ 2/4/08 5
CT 2/1/08 20
CT 2/2/08 12
CT 2/3/08 11
CT 2/4/08 8
Do you guys have any ideas how to create the layout input form like that?
Thanks in advance.
Can we use a lay out input like Pivot table and then we can save it in
regular table?
Sample for layout Input:
2/1/08 2/2/08 2/3/08 2/4/08
NY 25 10 10 5
NJ 15 8 5 5
CT 20 12 11 8
When the user enter that chart, Acces should save it in regular Table that
has 12 records like this:
State Date Amt
NY 2/1/08 25
NY 2/2/08 10
NY 2/3/08 10
NY 2/4/08 5
NJ 2/1/08 15
NJ 2/2/08 8
NJ 2/3/08 5
NJ 2/4/08 5
CT 2/1/08 20
CT 2/2/08 12
CT 2/3/08 11
CT 2/4/08 8
Do you guys have any ideas how to create the layout input form like that?
Thanks in advance.