Hello,
I am building a database for my office and I am learning Access as I go. I've got two questions that I hope have answers other than "you can't do that."
1. How can I export a file as a .csv file?
.csv file format is not offered as an option if you try to export to excel. When I exported as a text file and manually change the file extension to .csv it did save as the correct file type but the data was pretty badly scattered about the spreadsheet with odd spacing and several of my fields of information were merged into single cells which pretty much makes it useless for my purposes.
2. Can I set my export file name to auto-generated based on information in the report that is being exported?
Currently the export file name default is the name of the report, I would like the exported file to be named after the 'Date' and 'InvoiceNumber' (two fields that are in the report) automatically without me having to manually type that information in every time I export a file.
Thanks!