reports questions - viewing wong info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a very basic database to track deliverables. In it I have
used 3 tables
Deliverables (which holds all of the info)
Owners - (sales, analysts, finance)
Individual - actual people
I tried to get the owners and individuals to tie together so that if you
selected sales only the sales individuals would show up but that didn't work
- so i ended simply added columns into Deliverables with drop downs of Owners
and Individuals.

My form looks fine - i can go in change the owner/individual. I created a
query (to build a report off of and it looks fine. However the report shows
the id numbers associated with owners and idividuals. So instead of showing
me that john smith is past due it shows me #7 is past due.

Can somebody point me to where I should be looking. If I try to change the
properties of the field in the report i get an error and if i change any
relations i get type mismatch.

I am stumped.

Thanks so much.
 
You need to add a field to your query behind the report -- the field which
shows the plain english interpretation of #7. Replace the control source of
the box which showed you #7 with the field you added (the plain english
version). I'm having a very blond moment right now, so probably didn't
explain that very eloquently. Let me know if you need further
clarification.

Linda
 
My query already shows me the plain english of number 7 - only the report
shows me the id number. Does that make sense? My blone moment started when
I offered to create this stupid thing!!!!!
 
Look closely at your query. You probably have both of the fields (the
number value and the text value) showing. You've just selected the wrong
one to display in the report.

Linda
 
Back
Top