I have this following code:

---------------------------------------------------------
a = "MPI_CORE_DATA"

b = 'Need something here to get rid of the quotes in a

DoCmd.RunSQL "CREATE TABLE " & b
---------------------------------------------------------


How can i get rid of the quotes (") in a e.g. so "MPI_CORE_DATA" will become MPI_CORE_DATA

a = "MPI_CORE_DATA"

b = "CREATE TABLE " & a

DoCmd.RunSQL b

Did that work? Access does not like concatenation in the DoCmd. line.


mmcdonal

Look it up at: http://wrox.books24x7.com