Report returns id-numbers instead of text from query

  • Thread starter Thread starter Ed Jordan
  • Start date Start date
E

Ed Jordan

I am trying to make a report baised of a query that just shows the data in
the query.
the problem i am having is the in the query the data shows up correctly but
in the report it shows up as the id numbers of the data from the tables the
query is baist on.
 
On Tue, 22 Jul 2008 21:36:03 -0700, Ed Jordan <Ed
I am trying to make a report baised of a query that just shows the data in
the query.
the problem i am having is the in the query the data shows up correctly but
in the report it shows up as the id numbers of the data from the tables the
query is baist on.
Click to expand...

Sounds like you're yet another victim of Microsoft's "Lookup Wizard"
misfeature.

The query or table datasheet *appears* to contain the text. It
doesn't. It contains the numeric keys, and that simple fact is
concealed from your view by the Lookup Wizard's combo box!

Base your report - not on the table itself, or on a query just on the
table itself - but on a Query joining your table to the lookup table
(or tables). Pull the text field from the lookup table.
 
Could you give me an example on how to do this?
Click to expand...

Could you give me the names of your tables, their primary keys, and
indicate how the tables are related?

That would let me give you a tailored example to your situation.
 
Main Table:
Troops

ID*
Troop
District
Scoutmaster
SPL
Pre-Adult
Pre-Youth
On-Adult
On-Youth
Volunteer 1
Volunteer 2
OA 1
OA 2
Campsite
Total Attentendance
Cost
Amount Paid
Notes

2nd Table:
Patrols

ID**
Patrol Name
Patrol Leader
Troop*
Level

3rd Table:
Events

Event ID***
Event Name
Staff In Charge
Notes

4th table:
Score

Score ID
Event ID***
Patrol Name**
Score
Sprit
Total

The asterisks represent the relationships of the tables and the query i am
useing is baised off the Scores (4th) table. the primary keys are the ID
Thanks
Ed
 
John thanks for the help i figured out the lookup query from one of your
other posts

Thanks
Ed
 
Back
Top