Help: Copying a coded table

D

DDTrx2004

I want to copy a coded table, but everytime I try the new table inserts the
code (i.e. numbers) into the rows, but I need to see the actual text. Any
suggestions?

Thanks
 
J

John Vinson

I want to copy a coded table, but everytime I try the new table inserts the
code (i.e. numbers) into the rows, but I need to see the actual text. Any
suggestions?

Thanks
Click to expand...

First off:

It is VERY rarely necessary to copy a table. Storing data redundantly
is essentially NEVER a good idea.

Secondly:

If you're trying to create a Report or display data on a Form, you
should create a Query joining your table to the lookup tables which
contain the text. Base your Form or Report on this Query. No new table
is needed.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
D

DDTrx2004

Hi John,

I still am unclear on how to proceed based on your response. The problem I
have is that the query I made is based on various tables linked(or relateded)
to one another, but the query contains records that I do not want to look
at. I do not know how to make these records go away, because there is no
criteria I can use to distinguish them from the records I do want to see. I
thought I could copy this query to make a table, so I could just delete the
records I don't want to see without changing the data in the real tables.
The only problem is when I copy the query it shows the coded data (i.e.
numbers) and I need to see the text.

Any suggestions would be greatly appreciated.

Thank you
 
J

John Vinson

Hi John,

I still am unclear on how to proceed based on your response. The problem I
have is that the query I made is based on various tables linked(or relateded)
to one another, but the query contains records that I do not want to look
at. I do not know how to make these records go away, because there is no
criteria I can use to distinguish them from the records I do want to see. I
thought I could copy this query to make a table, so I could just delete the
records I don't want to see without changing the data in the real tables.
The only problem is when I copy the query it shows the coded data (i.e.
numbers) and I need to see the text.
Click to expand...

If you're using Microsoft's misleading, misdesigned, obnoxious
"Lookup" feature, that may be why you're having the problem. Your
table *APPEARS* to contain text; it doesn't. The text is in the Lookup
tables, and the actual contents of your table - the linking fields to
the lookups - are concealed behind the lookups. When you do a
MakeTable query, the actual data in your table is what comes across.

Instead of basing the MakeTable query on the lookup-infested table,
create a Query joining your main table to all of its Lookup tables.
Select the text fields from the lookup tables, not the (concealed) ID
from your main table. The resulting non-normalized table will contain
the text and will be editable.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top