Replacing values in a report

[Thorben Grosser]

Hey Newsgroup,

although I think my problem is simple, I can't figure out how to solve
it:
I got a database collecting folders. Every folder has a certain status
(1 = In Archive, 2 = Borrowed, 3 = Destroyed) stored in my table. When
showing the report, I want to show the text, not only the number, so I
have to replace those. How do I do that?
And why does the report, when eg some folder has the id 620 only show
62 and how do I correct this (with the format function?)

thanks a lot
Thorben Grosser

 

[Allen Browne]

Create a small table, with fields such as:
FolderStatusID Number primary key
FolderStatus Text
Enter the records, showing the number and the text.

Create a relationship between your original table and this one, based on the
numeric fields. (Relationships on the Tools menu, and make sure you check
the box for Referential Integrity.)

Create a query using your original table and this one. You can now include
the FolderStatus field (i.e. the text).

Base the report on the query. The text field is now available for your
report.

To show the full number, make your text box wider (in report design view.)

 

[Thorben Grosser]

Works fine, thanks a lot

Thorben