If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Data entries
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. |
#3
|
|||
|
|||
Data entries
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. |
Thread Tools | |
Display Modes | |
|
|