View Full Version : Quotation being added to a variable


XLEAccessGuru
09-18-2007, 07:34 AM
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!

KenHigg
09-18-2007, 07:58 AM
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 '.')

???