HI
I have an Access database that all the enquiries are logged into. These enquiries are logged into a spreadsheet each week, then at the end of each month a summary is done.
From the database a search is done for the enquiries that were logged in for the specific month. The table is then copied into an excel sheet.
I want to combine a few of these enquiry spreadsheets together to make everything logged for a month into one sheet.
How do I get a search from Access into the excel sheet?
The search will be the same each month (just dates altered, which are all on the spreadsheets).
Kieran
Bookmarks