Query not displaying properly in Report

[jlex]

I run a Query based on some data in a "drop-down" box. It works in just datasheet view, but when I print it on a report, it displays the position that the data is in the drop-down box.
How do I display the data, not the position on the report? Here's an example:
My drop down box contains:
apples
oranges
bananas

My query returns apples, but in the report view it displays the number "1" instead of my data "apples". If the query returned oranges, the report would display "2" instead of "oranges" and so on.

Any ideas?
Jen

 

[RuralGuy]

Are you per chance using a LookUp field in your table? If so then here's a link to read: The Evils of Lookup Fields in Tables

 

[jlex]

Yes, I do use a Lookup Table and it is the position in the lookup table that is being returned to my report and not the actual data.
Any way of displaying the actual data?

 

[RuralGuy]

I would suggest *not* using a LookUp field as the link explains. They only confuse the programmer!

 

[jlex]

I figured it out!


I use this statement as the "Raw Source" property.

SELECT [DropDown Box Field].Primary Key ID, [DropDown Box Field].Name FROM [DropDown Box Field];

 

[RuralGuy]

Glad to hear you got it sorted. Excellent.