We have a report that is generated monthly to management on Excel. We Export the data from an Access query to Excel and at that time the user has to update the Month Reported and Year Reported fields on each record within that query.
Can I set up something to where the user can click a button or something and Access do all of this automatically?
Example: May 2005 was just sent out and we exported the data from the query to Excel and went back into the query and chose update query and had Access fill in May (in the month reported field) and 2005 (in the year reported field) on all of the records.
Any help is appreciated, thanks...
Can I set up something to where the user can click a button or something and Access do all of this automatically?
Example: May 2005 was just sent out and we exported the data from the query to Excel and went back into the query and chose update query and had Access fill in May (in the month reported field) and 2005 (in the year reported field) on all of the records.
Any help is appreciated, thanks...