Sort on

[Guest]

Ok, so in my database, I have the reports and Queries set to sort on Company,
then by last name, however, when new ones are entered, in the middle of the
report is where they show up (ones with no Company). Any suggestions on how
to fix this?

 

[John W. Vinson]

Ok, so in my database, I have the reports and Queries set to sort on Company,
then by last name, however, when new ones are entered, in the middle of the
report is where they show up (ones with no Company). Any suggestions on how
to fix this?

Open the Report in design view; right mouseclick the little square at
the upper left; and select Sorting and Grouping.

Set the report's sort order there. It ignores the sort order in your
Queries.

I have no trace of a notion what you mean by "ones with no Company"
though; it may be that the NULL values of company are sorting in a way
you don't expect.

John W. Vinson [MVP]

 

[Guest]

John,
The companys are listed in the report. I have the sort on Company and then
Last Name. So the entries with no company are first. However, I've tried the
sorting and grouping and there's 204 pages of the report. On pages 30-34,
the report for some reasons restars the alphabetizing. For example we'll go
from a-z, then start back up with b, right before the contacts with companies
start. Any suggestions?

 

[John W. Vinson]

The companys are listed in the report. I have the sort on Company and then
Last Name. So the entries with no company are first. However, I've tried the
sorting and grouping and there's 204 pages of the report. On pages 30-34,
the report for some reasons restars the alphabetizing. For example we'll go
from a-z, then start back up with b, right before the contacts with companies
start. Any suggestions?

I wonder if there is something - perhaps a Zero Length String - in the
Company field for these records? Try creating a query with a criterion
of

< "A"

on the company field; this will pull only non-NULL companies which
might be causing the problem.

Another possibility: might some of the company fields have been
inadvertantly entered with a leading carriage return? They wouldn't be
visible in a one-line textbox or datasheet row. Try searching for

LIKE Chr(13) & Chr(10) & "*"

on the company field to see.

John W. Vinson [MVP]