Replace Data on Reports

J

John W

I'm very new to Access and I'm trying to learn to use it on my own. I've
created tables, queries and reports that will import an Excel sheet, sort
the information into correct group and parse out on individual reports.
This is all working fine but I have one more thing I'd like to do and can't
seem to figure it out. I want to be able to create a master list so to
replace certain data with something more readable. For example - anytime
the number 24 is in a certain column I want it replace with the text "Reason
Not Available". I have two columns in my basic table that I need this done
on. I'm guessing I need to create a macro but I'm having trouble getting
anything to work. Does anyone know what procedure I need to use for this?

Thanks for your help!
 
P

Pete D.

If these columns all have numbers or same type of data (number) then make a
table with all the possible numbers and description you want. Then join the
two tables on the number field in each, those fields should be key fields
with unique key. Next make a query to build your report off of and use
both tables. Just drag the field description to the query instead of the
number. There are other ways to do this but with you being new to access
this will be easier.
 
P

Pete D.

When I said should be key fields with unique keys I was speaking of the new
tables number fields. That way you can only have one description for each
number. Sorry about that.
Pete D.
 
J

John W

This worked and it was surprisingly easy! Guess I should have been able to
figure that one out on my own.

Thanks for your help!
 
Top