Automaticly genrate file Path name with Query

[kiwikiki718]

Hello, I have a database I use to export data into excel to send out emails. Currently to generate the path of a file, I have to export the data from the table into a report and then then insert a code to generate the path file name for the attachment before exporting to excel. The Email table includes the following fields: EmailAddress, Case, Subject, Body,Date and Attach(Blank). I wanted to know if there was a way to generate the path file name using a query so that I can input the path directly into the Email table instead of the report? and if so how.



I have tried to create a query to automatically generate the file name but get a error because of the "" and other invalid syntax

here is the path name I created in the report that works but I am unable to put this code in a query:

C :\Users\Earl_000\Documents\Pic\[Case]\[Date].pdf

[Micron]

What you want is concatenation, which can be tricky at times. Suggest you research it, but if you put this in a query design grid in the field row, you should get a result with a field name of Test.
Test: "C :\Users\Earl_000\Documents\Pic" & [Case] & "" & [Date] & ".pdf "
If you're in the mood to do more research, check out naming conventions and reserved words. Date is a poor choice for any db name, and the use of brackets as part of a field (Attach(Blank) ) name is not good either.

[kiwikiki718]

Great, This works!, I will read up on the links you provided. Thanks!!