There is a table that currently has the following fields:
CurrentMonth
Month
1a
1c
1d
2a
2c
...
CurrentMonth is a place for the user to 'X' the current month
Month = Jan, feb, etc
1a, 1c, ... = number of work days
What I would like to do is create a form that will open and display the data like:
Checkbox "Pick current Month"
currentMonth ___ ___ ___ .....
Days Jan Feb Mar ....
1A 15 10 5
1c 7 5 4
....
So that the user could go to the current month and just go down the list of day codes and update for that month
vers just having
Month 1a 1c 2a......
Jan 15 7
-There are so many day codes that would cause the form to seem extremely long if done like the above method -
I first thought of a crosstab query to get going, but I can not seem to get it formatted, so I thought that there may be a way to do this with columns, but have had no success in formatting the columns..
Any ideas?
CurrentMonth
Month
1a
1c
1d
2a
2c
...
CurrentMonth is a place for the user to 'X' the current month
Month = Jan, feb, etc
1a, 1c, ... = number of work days
What I would like to do is create a form that will open and display the data like:
Checkbox "Pick current Month"
currentMonth ___ ___ ___ .....
Days Jan Feb Mar ....
1A 15 10 5
1c 7 5 4
....
So that the user could go to the current month and just go down the list of day codes and update for that month
vers just having
Month 1a 1c 2a......
Jan 15 7
-There are so many day codes that would cause the form to seem extremely long if done like the above method -
I first thought of a crosstab query to get going, but I can not seem to get it formatted, so I thought that there may be a way to do this with columns, but have had no success in formatting the columns..
Any ideas?
