How do I join data from 2 fields in same query?

T

thjofe

I have a FirstName and a LastName field that I am trying to join in a query
under a column named Owner. The method that I am trying is as follows:

Owner: [FirstName] & " " & [LastName]

When I run the query it gives me a parameter value box instead of listing
the names.
I am new to Access and I am using Access 2003

Any help anyone can provide will be greatly appreciated
 
A

Allen Browne

First thing to check is that the spelling is correct.
For example, is there a space in the [First Name] field's name?

If not, tell us more about this query.
Is it a Totals query (GROUP BY clause)?
Do you have criteria on this field?

If you can't see anything obvious, switch to SQL View (view menu), and post
the SQL statement you see there.
 
Top