Query

  • Thread starter Thread starter Aaron Neunz
  • Start date Start date
A

Aaron Neunz

I have a STNUM field and a STNAME field I need to quickly append the STNUM
field to the STNAME field.
 
Aaron,
If you just want the 2 fields concatenated in a new
field, create a new expression in query like:

Confld: STNUM & " " & STNAME
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

splitting up a field? 7
Parsing Question 3
Vlookup Table - with L/U value as '100 1
Last Record overwritten using .AddNew 2
Cannot sort on calculated field in Query or Report 1
On Error GoTo stops working 2
Openform "where" problem 2
Picking up last record 2

Back
Top