report starts with diff ID

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

Guest

I created a form, the first display is record_id 44
I saved the form as a report. the first display is record_id 51.
why don't they match?


read on:

It seems like after I did a compact and repair,
all of a sudden my REPORT1 starts with record_ID 68
instead of record_ID 44.


ACCESS 2002 (10.2627.etc)
REPORT1 is comprised of some controls that go directly to
MAINTABLE, but also has almost a dozen smaller subreports,
some of which use reports. as a source, some forms. some
of the forms. are DATASHEET format, one is tabular, some
are columnar.
Funny things:
some of the sub-reports can start with record_ID 44
just fine if I run them independantly, others start with
record_ID 68
MAINTABLE seems uncorrupted - I can find all the
test data for all records
REPORT1 seems in tact otherwise, no other
malfunctions.........just can't point to record_IDs prior
to 68


SO I compacted again, and again, and again

and all of a sudden the REPORT1 started with record_ID 51
more compacts and repairs do not alter this, it remains
51, and all the above funny things hold true.
Can someone help me figure out what is going on?
 
Mark

No matter what you base your report on (query or table), the sort order in
the report must be set via the Sorting and Grouping for the report.
 
so what you mean is:

The Order by property must have been set to ID at one
earlier point in time and some how I inadvertantly either
turned off the Order BY or else erased the "ID" from
ORDER? and therefore the report is just sorting in a
different order?

Am I right, is that what you meant to
explain............or is there some other explanation?
 
Mark

Order By ... in what? The underlying query?

I was suggesting using the report's Sorting/Grouping feature.
 
Back
Top