Access 2003. I've got a table along with it's associated form. Users began inputting data on 11-18-10. We've had consecutive data for over a month now. We are now having to go back and input data from 10-1-10 thru 11-17-10. This This will enable users to retrieve data from day one of fiscal year 2011. Problem is...I don't like the out-of-sequence dates on the form as we sometimes have to scroll backwards. Is there a way to whip the sequence back into ascending order on the form?
Out of sequence
- Thread starter skydiver
- Start date
missinglinq
AWF VIP
- Local time
- Today, 13:17
- Joined
- Jun 20, 2003
- Messages
- 6,417
Set the Order By Property of the Form to TableName.FieldName, or create a Query based on the Table with the target field sorted. Then base the Form on the Query.
Linq ;0)>
Linq ;0)>
missinglinq
AWF VIP
- Local time
- Today, 13:17
- Joined
- Jun 20, 2003
- Messages
- 6,417
It's always a good idea, IMHO, to base Forms on Queries, even when only a single Table is involved.
You can create a Query on a Table, using the Query Wizard, in less than a minute, and a Query allows you to do all kinds of data manipulation, such as sorting, with a minimum of effort.
Linq ;0)>
You can create a Query on a Table, using the Query Wizard, in less than a minute, and a Query allows you to do all kinds of data manipulation, such as sorting, with a minimum of effort.
Linq ;0)>
