I simple issue. Please advise!

  • Thread starter Thread starter nest
  • Start date Start date
N

nest

I am creating a report and the report has a lot of
information divided into units. Each unit is described by
a number from 0 to 100 increase by ten units each. What I
would like to accomplish is to instead of printing in the
report the number 10, 20, 30, etc I would like to print
the Unit name. example; Machine Wide, Operator Load, Dial,
etc.

How do i do this? Please advise.

Thank you in advance for your help with this matter!
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The solutions below work on the assumption that you have a look-up table
that holds the UnitCode and the UnitName. E.g.:

Units
UnitCode UnitName
10 Machine Wide
20 Operator Load
30 Dial

Two ways I can think of:

1) When you want to be able to sort by the UnitName, include the column
that holds the unit name in the report's RecordSource query. E.g.:

SELECT U.UnitCode, U.UnitName, ...
FROM tblUnits As U INNER JOIN ... etc. ...

Then place the UnitName on the Report instead of the UnitCode.

2) Place a ComboBox on the report where you want the Unit name to
appear. The ComboBox's properties should look like this:

ControlSource: UnitCode
RowSourceType: Table/Query
RowSource: SELECT UnitCode, UnitName FROM tblUnits
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0";1" -- I've used inches. You may us a different

measure.

Using this method you will not be able to sort by the UnitName on 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/AwUBQIgqT4echKqOuFEgEQIH+gCgkvnPRXiWxpuKh+VQooUwl8gRSecAn17n
J5qcWWhgHXx0OFfw6+Arnw1r
=hE7H
-----END PGP SIGNATURE-----
 
I am creating a report and the report has a lot of
information divided into units. Each unit is described by
a number from 0 to 100 increase by ten units each. What I
would like to accomplish is to instead of printing in the
report the number 10, 20, 30, etc I would like to print
the Unit name. example; Machine Wide, Operator Load, Dial,
etc.
Click to expand...

Create a "lookup table" with two fields, a number and text, with
values

10 Machine Wide
20 Operator Load
30 Dial

<etc>

Join this table to your existing query by the number, and base your
report on the Query.
 
Back
Top