Report printing alpha instead of record order

[Guest]

I have a report that is printing the records in alpha order instead of record
# order. I have a command button on the form that prints the report when
clicked. The correct records are there, they're just in alpha order. I don't
have a sort anywhere that I can find, of course being new to Access there's
probably places I haven't looked. I checked the SELECT statement that is the
reports record source, but there's not a sort there of any kind. In the
properties there's no filter on or set. I'm not sure where else to look. I
would appreciate anyone's help on this.
Thanks,
RandyM

 

[Duane Hookom]

If you want to sort a report, open it in design view and view the Sorting
and Grouping dialog. If you select a field or enter an expression and it
still doesn't seem to work, come back with your field or expression and its
data type.

 

[Guest]

Duane,
Thanks for replying. The problem is I don't want it to sort. I want the
report to print out the way the records are entered, but for some reason the
report seems to be sorting them alphabetically. There isn't a sort anywhere
that I can find. Here's the SELECT for the report:
SELECT tblFamilyMembers.RelationsName, tblFamilyMembers.Relationship
FROM tblFamilyMembers WHERE
(((tblFamilyMembers.CustomerID)=[forms]![frmYardSales]![CustomerID]));

It has the right records, just sorts them alphabetically.
Thanks again for replying.
RandyM

 

[John Spencer]

In a relational database records do not have an order. It's like a sack of
marbles, there is no inate order.

If you have some field that will allow you to specify the order of entry,
then you can use that in the REPORT'S grouping and sorting. That is set up
using the View: Sorting and Grouping in the menu.

Any ORDER BY clause in the underlying query might well be ignored. It may
work, it may not.

If order of entry is important, then you need a date time field that saves
the entry time or a numeric field that you set the sequential value in.

Duane,
Thanks for replying. The problem is I don't want it to sort. I want the
report to print out the way the records are entered, but for some reason
the
report seems to be sorting them alphabetically. There isn't a sort
anywhere
that I can find. Here's the SELECT for the report:
SELECT tblFamilyMembers.RelationsName, tblFamilyMembers.Relationship
FROM tblFamilyMembers WHERE
(((tblFamilyMembers.CustomerID)=[forms]![frmYardSales]![CustomerID]));

It has the right records, just sorts them alphabetically.
Thanks again for replying.
RandyM

If you want to sort a report, open it in design view and view the Sorting
and Grouping dialog. If you select a field or enter an expression and it
still doesn't seem to work, come back with your field or expression and
its
data type.