Sometimes we can’t accomplish a formula in Access due to our skill level and the learning curve. We might feel like we wish that it was in Excel.
It’s easy to share data across the two programs.
Select the table or query from the database window. Drag and drop it into cell A1 (or wherever you want it in the spreadsheet) and release! Viola!
I have an earlier post that talks about the other direction!!!
