D
danfryp
I currently have a group of queries appending employee timesheet data from
linked excel tables into one main table.
I have set it up so that all these queries run under one macro, idealy this
macro will be run once a month to add that months timesheet data into the
main table.
I have created a new field in the main table called 'Month' and I want the
query to ask me each time it is run what month to input into this field. I
cannot use the 'Date the record is created' function as I will be inputing
data from the past year. Hopefully I have explained this properly and any
help would be greatly appreciated.
Many Thanks
Dan
linked excel tables into one main table.
I have set it up so that all these queries run under one macro, idealy this
macro will be run once a month to add that months timesheet data into the
main table.
I have created a new field in the main table called 'Month' and I want the
query to ask me each time it is run what month to input into this field. I
cannot use the 'Date the record is created' function as I will be inputing
data from the past year. Hopefully I have explained this properly and any
help would be greatly appreciated.
Many Thanks
Dan