how do i restrict my table to 20 entries (first in first out)

B

brane

I work with asp t oinsert data into acess table. i would like to resstrict
entries to 20
in the way FIFO first in first out
 
K

KARL DEWEY

Well there is one way I can think of.

Add a fields named My20 as a Yes/No field. Also add a field if you do not
have it to know First In - like and autonumber.

Use a form for your data entry and on close run a macro that runs two update
queries. The first query sets all My20 to No ( zero ). The second, sorting
descending the autonumber, top 20 update My20 to Yes ( -1 ).

All of your other queries need to have criteria set for My20 field to -1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I clear a form? 0
How to have two tables on same line? 1
Duplicate entry in a column/row 14
Linking Child Timelines to Multiple Parents 0
Embed the same Excel multiple times 0
Word 2016: How do I change a REF field code that references a Heading style to Arabic when the Headi 1
Insert Index into a Table 1
Synchronization problems while moving folders to new email 1

Top