Can someone please tell me if Access will do what I want to do, and if it can, how do I do it.<br><br>I have two databases, one with a complete list of equipment in a plant, the other lists the problems with plant equipment in chronological order.<br><br>I would like to make a form or query that as you entered equipment #'s, the last 10 equipment problems would be shown.<br><br>Can this be done?<br><br>Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query Help
- Thread starter chastst
- Start date
Yes it does exist.<br>Queries have a property called Top Values. You just need to sort the data appropriately. So in your case sort the data by Date - descending. Read the help file as well, as there are issues when more than one value are equal.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
