Hi,
I am trying to create a form for data entry. I'm fairly new to access...
The fields in the table are....
Location
Delivery_On_Time = Yes/No data entry
Week Commencing
Date
There are 15 locations to enter the yes/no against every day..
Is it possible to have the form set up so that Locations run down the side and date along the top.
Essentially so that the dates for the week are calculated based on the Week_Commencing Entry
I was hoping that there is a way so that they would only need to enter the Yes/No and the rest would be populated dependent on a link - i.e. Location 3 and 22/5/2008
Any help would be much appreciated....
Thanks in advance
Matt
I am trying to create a form for data entry. I'm fairly new to access...
The fields in the table are....
Location
Delivery_On_Time = Yes/No data entry
Week Commencing
Date
There are 15 locations to enter the yes/no against every day..
Is it possible to have the form set up so that Locations run down the side and date along the top.
Essentially so that the dates for the week are calculated based on the Week_Commencing Entry
I was hoping that there is a way so that they would only need to enter the Yes/No and the rest would be populated dependent on a link - i.e. Location 3 and 22/5/2008
Any help would be much appreciated....
Thanks in advance
Matt