Creating a Field in a query from 2 fields in a database table

S

Simon Holloway

I want to create a field in a query form 2 fields in a table (Surname and
Last name), so that I can create group field in a report. I have tried a lot
of things and nothing seems to work. Anyone got a solutin to my problem
 
R

RonaldoOneNil

Is Surname and Last name not the samr thing ??

Anyway, in your query just type this into the Field Row of a new column

NewFieldName: [Surname] & [Last name]
 

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

Can't create a report from my query in Access 1
combining two or more table fields into a single table field 1
Replacing information in a field with a linked table 10
Access Access - Is it possible to repeat fields in a form? 1
How do I concatenates two fields into one field in the same table? 3
Reformatting a name field 8
Name to Initials in table 9
Using a Parameter Query in a Report? 2

Top