Appending Data, adding " Marks around wording

[ezykiwi]

Hello all, Im trying to append data from one table in one database to another table in another database, my problem is... I have a field in the first database which has a value say 5 or 123 etc... but I need it to go into the other database as "5" or "123" , is there a way I can do this?

Any help would be awesome.

Cheers Ezy

 

[Rickster57]

Don't quote em

Create a query using your first table as it's recordsource. Create an expression in your query Expr: """" & [yournumber] & """". (2 sets of 4 quotes)Make the query an append query. Append the EXPR field to your text field in your second table

 

[ezykiwi]

Awesome, Thanks very much for that, thats awesome