Exporting Quieres - Filenames

[jquickuk]

Afternoon all,

I have my Vb script that runs my saved query. It then exports the results into a CSV file.

What i am having issues with is when i run the query it asks me to type in the date. This then shows the cancellations for that date.
I am trying to get the date i entered to become the file name.

Saved query: Cancellations.
Field name: Cancel_Date



Currently I have the follwoing.

filename = "Cancellations.Cancel_Date"

strFile1 = "C:\website cancellations\Cancellations " & Format(filename, "yyyymmdd") & ".csv"

it then saves the file fine but as: "Cancellations Cancellations#Cancel_Date"

Any ideas?

Thanks
John

[RuralGuy]

Why don't you do a MsgBox "FileName = [" & filename & "]"
...before sreating the strFile1 string and see what you have. You will probably need to use a DLookup() to actually get the value for which you are looking.