how to convert codes to names for printing of Access reports?

[kmnotes04]

I have a data entry form that contains drop-down lists such as
'Assigned to:' with a list of staff member names. Those names end up as
numerical codes in the main table ('ProjectInfo') of the Access
database. Is there some way - such as a SQL satement added to a query
already set up in Access - to add a statement such as 'if 1 then
'Smith', if 2 then 'Brown', if 3 then 'Williams' ', and so on? That
would be an automated way to quickly get names, instead of numbers, to
appear in project status reports.

Otherwise, I have to use the more manual approach I'm using now, which
is to manually update a "linker table" called 'Project_Personnel' by
typing in the inserted values (inserted via use of a data entry form)
from 'ProjectInfo' into 'Project_Personnel'. For example,
'Project_Personnel', for each ProjectID, contains three numerical
fields: one for the code for the Director's name, one for the code for
the Program Manager's name, and one for the code for the Staff Person's
name.

This "linker table", Project_Personnel, links back to smaller tables
such as the one comprised of the list of names of Directors; the one
comprised of the list of names of Program Managers; and also, the one
comprised of the list of names of Staff Members. That's the way I'm
currently using to get names, rather than numbers, to appear in the
project status reports created in Access.

[MGFoster]

km*******@hotmail.com wrote:

I have a data entry form that contains drop-down lists such as
'Assigned to:' with a list of staff member names. Those names end up as
numerical codes in the main table ('ProjectInfo') of the Access
database. Is there some way - such as a SQL satement added to a query
already set up in Access - to add a statement such as 'if 1 then
'Smith', if 2 then 'Brown', if 3 then 'Williams' ', and so on? That
would be an automated way to quickly get names, instead of numbers, to
appear in project status reports.

Otherwise, I have to use the more manual approach I'm using now, which
is to manually update a "linker table" called 'Project_Personnel' by
typing in the inserted values (inserted via use of a data entry form)
from 'ProjectInfo' into 'Project_Personnel'. For example,
'Project_Personnel', for each ProjectID, contains three numerical
fields: one for the code for the Director's name, one for the code for
the Program Manager's name, and one for the code for the Staff Person's
name.

This "linker table", Project_Personnel, links back to smaller tables
such as the one comprised of the list of names of Directors; the one
comprised of the list of names of Program Managers; and also, the one
comprised of the list of names of Staff Members. That's the way I'm
currently using to get names, rather than numbers, to appear in the
project status reports created in Access.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the same ComboBox on the report as you use on the input form. After
copying it to the report change it's ControlSource to the corresponding
column name in the report's query.

You can copy the ComboBox from the form to the report:

1) Open form in design view - copy ComboBox (right click on control,
select copy).
2) Close form & open the report in design view.
3) Click the section you want to place the ComboBox & right click &
select Paste.
4) Move the ComboBox to the location you want.
5) Close & save the report.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQjIF0YechKqOuFEgEQKkoQCgrW7ucOUsiNABIypO7VB21O IcAqgAn3Aq
GomFPob4lqFzbVparvd07Kds
=dg4P
-----END PGP SIGNATURE-----