Hey, I am very new to MS Access, but I am reasonably versed in VBA for Excel. Can someone tell me how I would go about pulling data from a DB to Excel.
I have to make an invoice up for customers so it will have a Date sold, product, No. Sold, unit price and the total cost.
So I am trying to pull data from 5 columns in the DB from a specified date to date. Eg, Nov 16th to Dec 15th. On top of that I am trying to pull the previous months invoices grand total in the same fashion, eg, Oct 16th to Nov 15th have that on this months invoice.
I can do the VBA on the excel side, but I have no clue where to start from the DB side.
Any help would be appreciated.