Report to print in same order as entered into the table

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

Guest

I have a form that data is entered into and I wish to print a report with the data in the same order. The data in the form is enetered in no alphanumeric order and the report resorts the data, also into no noiceable alphanumeric order. I have no sorting or grouping criteria set in the report and I cannot set any criteria because I want it printed exactly as entered. Hmmmmmmm
 
Shane said:
I have a form that data is entered into and I wish to print a report
with the data in the same order. The data in the form is enetered in no
alphanumeric order and the report resorts the data, also into no
noiceable alphanumeric order. I have no sorting or grouping criteria
set in the report and I cannot set any criteria because I want it
printed exactly as entered. Hmmmmmmm
Click to expand...

Shane,
A table contains no built in sort order, so if you wish to print a
report in the same order the records were entered, you will need to add
a field to your table. Populate it with the date and time the record was
entered.
In the Form's AfterUpdate event:

[TimeWrittenField] =Now()

and then use this field in the Report's Sorting and Grouping dialog to
sort by.
 
Thanks Fred, works like a bought one. Cheers.
-----Original Message-----
Shane said:
I have a form that data is entered into and I wish to print a report
with the data in the same order. The data in the form is enetered in no
alphanumeric order and the report resorts the data, also into no
noiceable alphanumeric order. I have no sorting or grouping criteria
set in the report and I cannot set any criteria because I want it
printed exactly as entered. Hmmmmmmm
Click to expand...

Shane,
A table contains no built in sort order, so if you wish to print a
report in the same order the records were entered, you will need to add
a field to your table. Populate it with the date and time the record was
entered.
In the Form's AfterUpdate event:

[TimeWrittenField] =Now()

and then use this field in the Report's Sorting and Grouping dialog to
sort by.

--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.
.
Click to expand...
 
Back
Top