Quotation being added to a variable

XLEAccessGuru

XLEGuru
Local time
Yesterday, 21:37
Joined
Nov 17, 2006
Messages
65
I have a piece of code that sets a variable as the following to set up a file name:

variable = y & ".mdb"

The variable is being returned as:

DaVinci_Request_B_Database_BER_FE.mdb"

Notice the quotation at the end. I'm stumped! What the heck!!! Can anyone suggest anything that would get rid of the quotation?at the end of the file name?

It seems to be happening at variable = y & ".mdb"

Thank you!
 
Q1. Are you using the immediate window to check this?

Thought 1: Try something really simple in the variable (Without the underscores, etc.)
Thought 2: Try something simple in the string (Say maybe loose the '.')

???
 

Users who are viewing this thread

Back
Top Bottom