Hi,

As I work on a project I add parts as I see them, not in any ascending/descending order just as they are input.
In my report they always sort even though there is no sort applied to the part no.
How can I maje the report reflect the form input.

This came about because as a drawing is checked in gets confusing when checking the report to the drawing which has the parts on them as well.

The parts are put on the drawing in no special order and are input in the project the same way.

Bill

In the table that stores your data create a "Data Entered " date field, DATA_ADDED_DATE (Date/Time Data type), or something similar. Set the Default Value property to =Now()

As data gets added into your table from your form, a Time Stamp will automatically get applied to each record. Cascade this "Time Stamp" field into your report's data source. In the design of the report use this same field to establish the report's Sorting and Grouping Setting.

I hope I understood your need and that I haven't further clouded your thinking...

Yes,

Thank you, can I do this with a time stamp as well?

Bill

Okay,

If I use the longtime in the format of the date, would that work?

Bill

Got it working, thanks

Bill