Data entries

[knockout competition]

Hi.

I am trying to restrict the number of data entries allowed in a table field.
The specific number of entries in this case 3.
There is only one field in the table and data will be entered through a form.

 

[Jeff Boyce]

Are you saying that you wish to have no more than three records in the
table? Your description sounds a little like you are trying to allow
multiple facts in a single record's field.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Barry A&P]

Knockout
How about using a query to show the top 3 records in a table. that way you
could have a history order of all the winners?

tbl Winners
ID (key)
Name

setup the following query.
(new query in design view>Right click>SQL View> paste this code..

SELECT TOP 3 winners.ID, winners.Name
FROM winners
GROUP BY winners.ID, winners.Name
ORDER BY winners.ID DESC;

Hope it helps