In a query based on your table, add a new calculated field:

instead of the fieldname enter an expression,  here is an example:

FullName: [firstname] & " " & [lastname]


-------------- Original message -------------- 
From: "scolbertrocks" <[EMAIL PROTECTED]> 
Hey guys,
i have 2 fields, each in a second table that i want to combine into one 
field (probably in a query)i have no idea how to do it so....
plz help
thanx


 

[Non-text portions of this message have been removed]

Reply via email to