It would be a similar fashion, but I suspect that we will run into the same type of issues if you are unable to get this other thing to work.
But there is a way around this, where I can give you the EXACT code you need. I just need you to do the following.
- Create a new Select query in Access.
- Add all the fields that you want to export to your Query view
- Be sure to include "Report Date" field
So there is nothing special going on here - just a simple Select query - no calculations, no criteria.
Confirm that is working (by going to Datasheet View).
Once you confirm that, change the query to SQL View, and copy and paste the SQL code here for me.
Once I have this, I should be able to manipulate it to work for you.
Using Access 2007
Proficient in Access, Excel, VBA, and SQL