ACCESS QUERY

[Guest]

Is there any way in Access that I can combine two columns into one

 

[Carl Rapson]

Is there any way in Access that I can combine two columns into one

Are you wanting to simply display the two columns joined together, or are
you wanting to physically combine the two columns in the table? To display
two fields together, do something like this in a query:

SELECT ([field1] & [field2]) AS [newfieldname] FROM

...

To physically combine two columns in a table, create the new column in the
table and then run a query something like this:

UPDATE

SET [newfield]=[field1] & [field2];

Carl Rapson