Concatenate 2 variables into one?

cpopham · December 5th, 2003, 10:36 AM

I would like to know if it is possible to concatenate 2 variables into one?

Example:

Dim strTbl As String
Dim strDate As String
Dim strNewTable As String
strDate = CStr(Date)
strTbl = Tbl
strNewTable = strTbl & strDate

My goal is to combine these two variables into one and name a table with the new concatenated variable.

Does anyone know how to accomplish this? I can already name a table with just a normal variable.

Thanks, Chester

Steven · December 9th, 2003, 01:33 AM

Do you mean something like this:

Code:

SELECT Field1, Field2, [Field1] & [Field2] AS NewField
FROM YourTable;

Which is a simple select query, that can obviously be changed to an INSERT query.
by putting

Code:

INTO NewTable

at the end

HTH

Steven

I am a loud man with a very large hat. This means I am in charge

cpopham · December 9th, 2003, 10:27 AM

I got what I need thanks :)

Example (in case anyone else ever needs it):
Dim strMonth As String
Dim strYear As String
Dim strMonthYear As String
strMonth = Month(Date)
strYear = Year(Date)
strMonth = Month(Date)
strYear = Year(Date)
strstrMonthYear=strYear & "_" & strMonth

Chester