Oct 17 2007, 12:08 PM
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.
Oct 17 2007, 02:54 PM
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...
Oct 17 2007, 03:04 PM
Thank you, can I do this with a time stamp as well?
Oct 17 2007, 03:15 PM
If I use the longtime in the format of the date, would that work?
Oct 17 2007, 03:46 PM
Got it working, thanks
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here