Re: I WANT REPORTS IN ACCESS TO INDEX IN THE SAME MANNER I HAVE TH
From: Larry Linson (bouncer_at_localhost.not)
Date: 01/31/05
- Next message: miker042: "Exporting a Report from Access 2003 to Excel is missing Text field"
- Previous message: Larry Linson: "Re: Problem with displaying and printing main report w/ 7 subreports"
- In reply to: ARNYS: "Re: I WANT REPORTS IN ACCESS TO INDEX IN THE SAME MANNER I HAVE TH"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 30 Jan 2005 22:18:12 -0600
Is the Field you chose on which to sort actually a Field in the RecordSource
of the Report?
That message implies that it is due to an expression being evaluated. It
could result from something other than your adding the Sort, though it
certainly is suspicious that it happened just after you chose a Field on
which to Sort.
Just for the record, what version of Access are you using, and what is the
level of Service Pack that has been applied (both should be available from
Help | About)?
Larry Linson
Microsoft Access MVP
"ARNYS" <ARNYS@discussions.microsoft.com> wrote in message
news:2CFA3DBA-579C-463C-9DC7-C9B9C8544517@microsoft.com...
> This was good advice and I tried it and I got the following message:
>
> "This report is to complicated to complex to be evaluated. For example, a
> numeric expression may contain too many complicated elements. Try
> simplifying the expression by assigning parts of the expression to
variables."
>
> I went to sorting and grouping in the report design mode and chose a field
> to be indexed and selected ascending and got the message above when I
> previewed the report. The group properties are marked as follows:
>
> group header no
> group footer no
> group on blank
> group interval 1
> keep together no
>
> I cannot figure out how to make that message go away so the report will
run
> and be indexed as I desire it.
>
> thanks for the help!
>
> Arny
>
> "Larry Linson" wrote:
>
> > "ARNYS" <ARNYS@discussions.microsoft.com> wrote
> >
> > For other good suggestions on effective use of newsgroups, see the FAQ
at
> > http://www.mvps.org/access/netiquette.htm.
> >
> > In addition to putting the question in the body of the post, you'll find
> > that posting in all caps is considered "shouting" and considered to be
> > impolite.
> >
> > Guessing your issue was "I want the data in my reports sorted in the
same
> > order as the query I am using for record source," I will have to tell
you,
> > "Sorry, the order of the RecordSource of a Report or Form is not
material.
> > You must specify the sort order in the Report's Sorting and Grouping
> > Properties."
> >
> > Larry Linson
> > Microsoft Access MVP
> >
> >
> >
> >
- Next message: miker042: "Exporting a Report from Access 2003 to Excel is missing Text field"
- Previous message: Larry Linson: "Re: Problem with displaying and printing main report w/ 7 subreports"
- In reply to: ARNYS: "Re: I WANT REPORTS IN ACCESS TO INDEX IN THE SAME MANNER I HAVE TH"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
