EmmaJane
Registered User.
- Local time
- Today, 20:09
- Joined
- Nov 5, 2003
- Messages
- 214
Okay I know what I would like but not sure the best way to explain it!
We have a very high turn over of staff and clients, which generate a lot of files that we need to hold for seven years. Therefore our archive is large. I have a table in access that holds both client and staff and the box number they are placed in. I have now created a form for new entries to this table. What I would like is somewhere on this form a control that shows what the last box number was ??
I’ve done some reading on Dmax but not sure how to use it in this circumstance?
We have a very high turn over of staff and clients, which generate a lot of files that we need to hold for seven years. Therefore our archive is large. I have a table in access that holds both client and staff and the box number they are placed in. I have now created a form for new entries to this table. What I would like is somewhere on this form a control that shows what the last box number was ??
I’ve done some reading on Dmax but not sure how to use it in this circumstance?