Hi all, hopefully the title makes sense.
I am looking for the best way to create a daily table of data (snapshot for edit from a static table) based on what day it is.
So, for example in a table I have
| Name | Monday | Tuesday | Wednesday | Thursday | Friday |
Each day has different set values for each Name
So I would like to make a new table (make table query, or even an append into another table) with the Name and whatever day I want to choose, whether it be from a combo or it could be based on the current day, I just don't know how to call the specific column in the query.
I have searched the forums but cannot find anything, I cant help but think this is a lot easier than I think and just missing a simple trick.
Any help very much appreciated.
thanks
Alex