Gabriela said:
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
