Converting Field Values For Reporting Purposes...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dlemarr - 14 Oct 2004 15:17 GMT

I am new to the world of MS Access, but I do understand the basics. The
values are for a field named Error Reported How? (This is for an Error
Reporting Database). For example, I have 5 different field values that they
can choose from a combo box. Agent, Customer, QC Function, Processor, and
Post Process. These values are used to determine if the error got out the
door to the client. If the error was reported by the customer or agent it is
considered a Reportable error. If the error was reported via the QC Function
or Processor, then it is considered Non-Reportable. Post process is
considered Potentially Reportable. This information is provided to upper
management. I am trying to create a report that will convert the values to
either Reportable, Non-Reportable or Potentially Reportable. I am at a loss
as to how to set this up. Any help would be greatly appreciated.

Reply to this Message

Duane Hookom - 14 Oct 2004 16:47 GMT

You should have a lookup table (not a lookup field see
http://www.mvps.org/access/lookupfields.htm) that has values like:

ErrorTitle Reportable
======== ========
Agent 1
Customer 1
QC Function -1
Processor -1
Post Process 0

This allows you to join the lookup table to your existing table in a report
so you can group by the reportable field.

Since you are new, you might want to check out
http://www.mvps.org/access/tencommandments.htm and the tips at
http://www.granite.ab.ca/access/tipsindex.htm. Find a naming convention and
stick with it.

Signature

Duane Hookom
MS Access MVP
--

> I am new to the world of MS Access, but I do understand the basics. The
> values are for a field named Error Reported How? (This is for an Error
[quoted text clipped - 8 lines]
> either Reportable, Non-Reportable or Potentially Reportable. I am at a loss
> as to how to set this up. Any help would be greatly appreciated.

Reply to this Message