Hi guys,
I have been stuck on this database for a very long time. I know the solution might be really simple, but because of my lack of knowledge in access i am not able to make it happen.
i have attached the database here so please have a look if you can
what I want to do is ask the user to enter values for "Total Available" and "Total Actioned" for each activity. This task will be used daily so new values should be stored under the activity.
Forexample, in the DaysOnly tab I want to show all the DaysOnly activities to the user and let them enter values for Total Available and Total Actioned for each day...
I am so confused in what joins to use, what structure and I have been unsuccessful like 100 times...
I would really appreciate if someone can let me solve this ..
thank you!!