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

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

--
Duane Hookom
MS Access MVP
--

"_Bigred" <nellSPAMREALLYSUCKSiott@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Q0RIf.5202$xZ4.1431@xxxxxxxxxxxxxxxxxxxxxxxx
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


"Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxxx> wrote in message
news:%23xOykfeMGHA.3856@xxxxxxxxxxxxxxxxxxxxxxx
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.

--
Duane Hookom
MS Access MVP


"_Bigred" <nellSPAMREALLYSUCKSiott@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:m%xIf.3795$CV.1748@xxxxxxxxxxxxxxxxxxxxxxxx
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









.

Relevant Pages

  • Re: Best way to import text file into existing table on a daily ba
    ... One is a title of the report and the second row are field names. ... "Ken Snell " wrote: ... permanent table -- although having them the same will allow the query design ... <MS ACCESS MVP> ...
    (microsoft.public.access.externaldata)
  • Re: Sort Multi Time Fields
    ... Ken Snell ... <MS ACCESS MVP> ... I do have the report sorting and grouping by ... Save the query. ...
    (microsoft.public.access.reports)
  • Re: my report ignores my sort criteria
    ... That's good to know about the wizard, in case I need to set up something ... Criteria row in the query design view: ... you for the membership type when you open a report based on the query. ... You can select only those individuals who are volunteer, community, ...
    (microsoft.public.access.reports)
  • Re: Crosstab Report
    ... MS Access MVP ... some of the information you posted to the query and found it very useful. ... would like to choose the year the report starts. ... Specify the column names in the query's Column Headings ...
    (microsoft.public.access.reports)
  • Re: Sort Multi Time Fields
    ... <MS ACCESS MVP> ... When it sorts now, it sorts numerically (ex: ... I do have the report sorting and grouping by date ... Save the query. ...
    (microsoft.public.access.reports)