m17347047711116
Registered User.
- Local time
- Today, 18:47
- Joined
- Feb 4, 2002
- Messages
- 68
I have a sub form that is based on a query
The form is set for continuous form view but i would like only to see the last 5 records
Problem, i have used the top 5 command in my query but is shows the last 5 decending
5
4
3
2
1
New Record
I would like to see the last 5 records in acending order however when i change the order to acending i see only the first 5 records in the table not the last 5 records
1
2
3
4
5
The form is set for continuous form view but i would like only to see the last 5 records
Problem, i have used the top 5 command in my query but is shows the last 5 decending
5
4
3
2
1
New Record
I would like to see the last 5 records in acending order however when i change the order to acending i see only the first 5 records in the table not the last 5 records
1
2
3
4
5