prob with sort in report (query fields dont show up)?

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

Using Office XP - Access
.............

I have a query that is based on a main table. When I run the query
everything works good, all fields from the table show up in the query.

However when I use the report wizard, and use the query as the source.. it
doesn't show the
Name field from the query
Category field from the query

I have deleted the report, and tried to recreate it but no luck.
I have tried to remove some fields from the report (to make sure I was
limited) - the query has about 15 fields that I want to show in the report
(then print in landscape mode).

TIA,
_Bigred
 
Are you suggesting the Name field is only missing in the Wizard? This might
be because name is a poor name for an object that has a name property. You
can always modify a report once the wizard finishes.
 
Main Table --> memo field named "Name" and field named "category"

switched Main Table --> memo field named "Name" to "PresetNAME", it is
visible on my queries but as soon as I create a report neither of these 2
fields show up? In the query they are selected to be shown?

TAIA,
_Bigred
 
Do you need them to show up in the wizard? Do you realize you can't sort or
group by a memo field?
 
Hello Duane,

Bam!! I changed the fields to text fields and that fixed my problem.

Can't believe that I missed that somehow. Thanks for the help.
Take Care,
_Bigred
 
Back
Top