Report Display Problems

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

Guest

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
 
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
 
Back
Top