- Aug 30, 2005
I have a form that we call a "check request form" in Excel. Our customer database is in Access. There are certain feilds in the Excel book that I need to automatically pull from our database. I tried building an Access query in Excel, and it worked, but not exactly how I needed it to. I need to run the query based on a date the user enters, then have an Excel sheet populate for each individual result. I need to pull a name, cash amount, address, city, state, zip, etc. and have it populate certain feilds in the Excel file. I am probably not explaining this well, but if anyone has any ideas, I would GREATLY appreciate it. Happy holidays, and thanks in advance!