Keeps returning wrong Column

[Wrecker]

In a table I have 2 Columns. The first is 1,2,3,4,5,6. The second 2 Chopper, 3 Chopper, ect. When I run my query I get a return that says "2 Chopper" (What I want}. When I run the report (that was created from the Query) I get "1"instead of "2 Chopper". How do I get the report to return the text from column 2? I have the properties set to Column count 2, and Bound column 2.

Thanks
Wrecker

 

[Darrylles]

Hi,

Look at the property of the field on the report.

Is it referring to the correct field in the table?

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk