Report Display Problems

M

MRL

Hi,
Have a report generated by a query. In the query everything is fine but in
the report rather than showing the "Drawing #" value it shows the
corresponding ID number for the "Drawing #". Trying to sort using this
"drawing #" field, if I delete this field then drag it over again from the
field list the drawing number now appears but it won't sort properly. This
text box "Drawing #:" is located in the Drawing #: header generated when I
use the Report wizard. Any clues?
Mike
 
O

OfficeDev18 via AccessMonster.com

Mike,

Have you checked the Sorting and Grouping list? That should clue you in to at
least part of your problem.

This text box "Drawing #:" is located in the Drawing #: header ...

I hope you're not repeating Drawing # in the Details section of the report.
You could be confusing Access by having the same field in two different
sections.

Hope this helps,

Sam
 
Top