Data entries

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.

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

"knockout competition" wrote
in message ...
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.

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 viewRight clickSQL 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

"Jeff Boyce" wrote:

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

"knockout competition" wrote
in message ...
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.