(Msg. 1) Posted: Thu Oct 09, 2008 3:12 pm
Post subject: Data entries Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
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.
(Msg. 2) Posted: Thu Oct 09, 2008 4:36 pm
Post subject: Re: Data entries [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <knockoutcompetition DeleteThis @discussions.microsoft.com> wrote
in message news:23FD47B2-3717-4AAA-BD38-84E5DF45F5E0@microsoft.com...
> 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.
(Msg. 3) Posted: Thu Oct 09, 2008 5:53 pm
Post subject: Re: Data entries [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
"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" <knockoutcompetition.DeleteThis@discussions.microsoft.com> wrote
> in message news:23FD47B2-3717-4AAA-BD38-84E5DF45F5E0@microsoft.com...
> > 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.
>
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other