Record Order Reversed in Report

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

I created a customer order form with a subform for
entering products. This then prints a preview of a PO
confirmation report. I don't want a sort on the products
ordsred so I have set OrderByON to No. I need the product
records to print out in the order they are entered in the
customer order form. Instead, they display in the exact
reverse order on the PO confirmation report....first item
entered in subform is the last item in the PO report and
last item entered is the first item. There is no order to
the records in any of the fields so they aren't sorted in
any way. Could this be a bug since I used the Microsoft
Customer Order template database and have Office XP Pro
with the latest SP2 applied?

Appreciate any suggestions! Thank you...
 
Jake said:
I created a customer order form with a subform for
entering products. This then prints a preview of a PO
confirmation report. I don't want a sort on the products
ordsred so I have set OrderByON to No. I need the product
records to print out in the order they are entered in the
customer order form. Instead, they display in the exact
reverse order on the PO confirmation report....first item
entered in subform is the last item in the PO report and
last item entered is the first item. There is no order to
the records in any of the fields so they aren't sorted in
any way. Could this be a bug since I used the Microsoft
Customer Order template database and have Office XP Pro
with the latest SP2 applied?
Click to expand...


Realational database theory (and many implementations of it,
even Access) do not have any order to the records in a
table. Think of a table as a bucket that you can pour
records into and pull bunches of records out of, they're
sorted after you pull them out.

The ONLY way to get records to appear in a specific order is
to use a query to sort on the fields in the table. (Note,
this may appear to be different for reports where the order
of records is specified using the Sorting and Grouping
feature, but internally, Access constructs a query to take
care of it.
 
-----Original Message-----
Jake said:
I created a customer order form with a subform for
entering products. This then prints a preview of a PO
confirmation report. I don't want a sort on the products
ordsred so I have set OrderByON to No. I need the product
records to print out in the order they are entered in the
customer order form. Instead, they display in the exact
reverse order on the PO confirmation report....first item
entered in subform is the last item in the PO report and
last item entered is the first item. There is no order to
the records in any of the fields so they aren't sorted in
any way. Could this be a bug since I used the Microsoft
Customer Order template database and have Office XP Pro
with the latest SP2 applied?
Click to expand...


Realational database theory (and many implementations of it,
even Access) do not have any order to the records in a
table. Think of a table as a bucket that you can pour
records into and pull bunches of records out of, they're
sorted after you pull them out.

The ONLY way to get records to appear in a specific order is
to use a query to sort on the fields in the table. (Note,
this may appear to be different for reports where the order
of records is specified using the Sorting and Grouping
feature, but internally, Access constructs a query to take
care of it.

--
Marsh
MVP [MS Access]
.
Thank you for your quick response. Can you give me some
Click to expand...
guidance on how I can get the data to print out in the
same order as I enter it in the form? Do I need to create
a line item number?...will that work?
 
Jake said:
Thank you for your quick response. Can you give me some
guidance on how I can get the data to print out in the
same order as I enter it in the form? Do I need to create
a line item number?...will that work?
Click to expand...


You could create a function that would calculate a number
for each record, but, if all you really want is to keep
track of their entry order, the a date/time stamp would be
sufficient. This is easily done by adding a Date/Time field
to the table and setting its Default Value to Now(). Then,
every new record will be time stamped when it is created and
you can create a query that sorts on the Date/Time field.
 
Back
Top