I've gone to design and to the Sorting and Grouping and listed the company
name in ascending order. Still doesn't help. I have a second sort for date
and eliminated that sort, but it continues to sort incorrectly. I'm
wondering if it isn't in the query or table design?
[quoted text clipped - 10 lines]Karen,
OfficeDev18 via AccessMonster.com said:Doesn't matter, Karen. The Sorting and Grouping settings govern.
A different question: Is your report's company name control bound to the
report's record source's company name field, and is it the exact same name as
that field, or is it either 1) a different name, or 2) unbound but "fed" its
data by VBA?
Sam
I've gone to design and to the Sorting and Grouping and listed the company
name in ascending order. Still doesn't help. I have a second sort for date
and eliminated that sort, but it continues to sort incorrectly. I'm
wondering if it isn't in the query or table design?
[quoted text clipped - 10 lines]Karen,A's it starts with the C's and then runs through the alphabet..then starts
with the A's
I think we're getting close. Here is the structure...I'm a novice at design,
so please forgive my inability. The company name field is generated from a
table and the field is a lookup field. After review, the sort is defaulting
to the ID field of that table. Does that answer your question? I appreciate
your help.
[quoted text clipped - 15 lines]Doesn't matter, Karen. The Sorting and Grouping settings govern.
OfficeDev18 via AccessMonster.com said:It follows then, Karen, that the ID field must appear in the Sorting and
Grouping grid. Delete it.
It's either that, or...
Look in the Preoperty Sheet for the report itself. Check if the Order By
property has an entry. It might just mention the ID field. If it does, delete
it. And set Order By On to No.
Hope we really are getting closer, and you're welcome,
Sam
I think we're getting close. Here is the structure...I'm a novice at design,
so please forgive my inability. The company name field is generated from a
table and the field is a lookup field. After review, the sort is defaulting
to the ID field of that table. Does that answer your question? I appreciate
your help.
[quoted text clipped - 15 lines]Doesn't matter, Karen. The Sorting and Grouping settings govern.A's it starts with the C's and then runs through the alphabet..then starts
with the A's
Checked both...It's not in either. It is sorting by the original table id
field, even though I don't have that in the query that I use to select the
data, and sorting 103..105..11..113..153..218.. These are the original ID
numbers. Is there some way to have it sort by that field..even though it
isn't in the query?
[quoted text clipped - 20 lines]It follows then, Karen, that the ID field must appear in the Sorting and
Grouping grid. Delete it.
OfficeDev18 via AccessMonster.com said:It follows then, Karen, that the ID field must appear in the Sorting and
Grouping grid. Delete it.
It's either that, or...
Look in the Preoperty Sheet for the report itself. Check if the Order By
property has an entry. It might just mention the ID field. If it does, delete
it. And set Order By On to No.
Hope we really are getting closer, and you're welcome,
Sam
I think we're getting close. Here is the structure...I'm a novice at design,
so please forgive my inability. The company name field is generated from a
table and the field is a lookup field. After review, the sort is defaulting
to the ID field of that table. Does that answer your question? I appreciate
your help.
[quoted text clipped - 15 lines]Doesn't matter, Karen. The Sorting and Grouping settings govern.A's it starts with the C's and then runs through the alphabet..then starts
with the A's
Sorry Sam..Bad info. In the property grid for report yes is on in the Order
By ON, and [BP Copies Quarterly Query].Date is listed in the order by field.
[quoted text clipped - 20 lines]It follows then, Karen, that the ID field must appear in the Sorting and
Grouping grid. Delete it.
OfficeDev18 via AccessMonster.com said:What happens when you delete the Order By info, and/or set order By On to No?
Does it sort correctly now?
Sam
Sorry Sam..Bad info. In the property grid for report yes is on in the Order
By ON, and [BP Copies Quarterly Query].Date is listed in the order by field.
[quoted text clipped - 20 lines]It follows then, Karen, that the ID field must appear in the Sorting and
Grouping grid. Delete it.A's it starts with the C's and then runs through the alphabet..then starts
with the A's
Sorry Sam..No change.
[quoted text clipped - 9 lines]What happens when you delete the Order By info, and/or set order By On to No?
Does it sort correctly now?
OfficeDev18 via AccessMonster.com said:OK, Karen. Now go into Sorting and Grouping and enter the company name and
ascending order and try it again.
make sure there are no other entries on top of this. If there are, delete
them.
Sam
Sorry Sam..No change.
[quoted text clipped - 9 lines]What happens when you delete the Order By info, and/or set order By On to No?
Does it sort correctly now?A's it starts with the C's and then runs through the alphabet..then starts
with the A's
No change..
[quoted text clipped - 10 lines]OK, Karen. Now go into Sorting and Grouping and enter the company name and
ascending order and try it again.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.