J
j
I don't know much about programming or Access, and I am trying to create a
schedule change database; retaining all past, present, and future records. Is
there a way I can select a record by the date?
For example:
ID Date Person
1 1/1 A
2 1/1 B
3 1/1 C
4 1/2 A
5 1/2 C
6 1/3 B
7 1/4 A
If today is 1/2, I want the report to display every employee's record that
is scheduled today (ID 4, 5) and the previous records for all other persons
(ID 2).
And when tomorrow comes around, if it to replace ID 2 with ID 6.
Is this even possible? Please HELP!!!
Thanks!
j
schedule change database; retaining all past, present, and future records. Is
there a way I can select a record by the date?
For example:
ID Date Person
1 1/1 A
2 1/1 B
3 1/1 C
4 1/2 A
5 1/2 C
6 1/3 B
7 1/4 A
If today is 1/2, I want the report to display every employee's record that
is scheduled today (ID 4, 5) and the previous records for all other persons
(ID 2).
And when tomorrow comes around, if it to replace ID 2 with ID 6.
Is this even possible? Please HELP!!!
Thanks!
j