getting name into 1 field from 2 fields

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

How do I go about do the following:

I have InmateInfo table
"LastName" field
"FirstName" field
"InmateNumber" field

How do then use that data in one field on a "JobROSTER" form in a "Worker"
field

So take the following
Doe
John
123456

and make it into one field so it will appear Doe, John #123456

Or is there a better way of doing this. For all purposes a inmate's
InmateNumber will never change as long as he is incarcertated. So even
autofilling his data based on his InmateNumber would work too, I just don't
know how to go about this problem?

TIA,
_Bigred
 
Dear Bigred:

How about:

LastName & ", " & FirstName & " #" & InmateNumber

If the values in LastName and FirstName are space filled, you might need to
RTrim() them.

Tom Ellison
 
Tom,

I hate sounding stupid, but where exactly do I put the LastName & ", " &
FirstName & " #" & InmateNumber?

Do I put it on the criteria line in a query, or do I set it as the source
properties for a texbox field?

Sorry,
_Bigred
 
Dear Bigred:

I was expecting you would put this in the "Field:" row of the query design
grid. Something like:

Calc: LastName & ", " & FirstName & " #" & InmateNumber

The "Calc:" give a name to the column created. The rest is the
calculation.

This is the typical way of creating a calculated column in a query.

Tom Ellison
 
Back
Top