Changing Output Names on a Group By

  • Thread starter Thread starter Charles D Clayton Jr
  • Start date Start date
C

Charles D Clayton Jr

A2K

I have a simple query where I group by on several fields. I would
like to change the output of one of the fields to a more descriptive
name. For example

03-H-02 FO
03-H-02 FS
03-H-02 BW

I would like to change it so that is outputs like this

03-H-02 OletWeld
03-H-02 SocketWeld
03-H-02 ButtWeld

The data has FO, FS & BW but I would like to make that more
descriptive for some people. Is there a way that I can do this in a
query or in a report?

Thanks,

Charles D Clayton Jr
 
Charles said:
A2K

I have a simple query where I group by on several fields. I would
like to change the output of one of the fields to a more descriptive
name. For example

03-H-02 FO
03-H-02 FS
03-H-02 BW

I would like to change it so that is outputs like this

03-H-02 OletWeld
03-H-02 SocketWeld
03-H-02 ButtWeld

The data has FO, FS & BW but I would like to make that more
descriptive for some people. Is there a way that I can do this in a
query or in a report?
Click to expand...


The "proper" way to do this kind of thing is to create a
table with two fields, one for the abreviation and the other
for the full descriptive name. Then you can use a query
with a Join from your existing table to the new table and
display both fields.

This additional table could also be used in a combo box on
your forms so the users could see the full decription when
they select the operation.
 
Back
Top