10-18-10, 13:08 #1Registered User
Provided Answers: 2
- Join Date
- Oct 2010
- Atlanta, GA
Unanswered: Apply rules to change query results for a report?
I had a hard time putting this one into word,s perhaps because it is Monday. Basically I have a query that gets all the data ready for a report. Everytihng works as expected. The problem is, I have many columns and limited space on the report, so I would like to abbreviate some of the wider columns.
For example, in column "Milestone", one record could be "Heat Treat / Surface Process 2". This take up a ton of space, so I would like to abbreviate it to "HT/SP 2". Is there a way to apply these types of rules to query results?
10-18-10, 13:22 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
consider moving the milestone to a separate table and use a code. use that code in the maintable as a FK to the milestone table
so you would have
HT/SP2 Heat Treat ? Surface Process 2 HT/SP3 Heat Treat ? Surface Process 3 INSP INSPECTIOn and so on
it has the added advantage that you immediately see what products are at which milestone status. rather than relying on users spelliingI'd rather be riding on the Tiger 800 or the Norton