automatically assign times

  • Thread starter Thread starter S
  • Start date Start date
S

S

I have created a database for running a competition.
My Table is called Entries
Some fields in table are
Entry #
Session
Time
I have already assigned a Entry # to each routine.
Because of the amount of entries we typically have for the competition, we
divide the competition into 5 sessions. I have already assigned each entry to
a certain session as well.

So now I would like access to ask me what time Session 1 starts.
Find the first entry # in Session 1 and input that time in the Time field.
Each Entry # is 4 minutes long.
Now I would like access to go to the next Entry # in that Session and
input that time and so on.

After Session 1 is completed I would then like it to ask me what time the
next Session starts and input all the times for each Entry # in that session.
And so on until all Sessions are completed and every Entry # now has a Time
automatically assigned to it.
 
If you have more than one Entry for each Session, then you need two
tables (at a minimum). It might look like;

tblSessions
********
SessionID (autonumber Primary Key)
SessionDescription
StartTime

tblEntries
*******
EntryID (autonumber PK)
EntryDescrition
SessionID (Foreign Key to tblSessions)


Then you would only enter the start time once for each Session. You could
easily tell the start time for an Entry by the Session it is related to.
 
I want the start time of each Entry # not just the start time of each session.

For example

I will be creating a report that will lool like....

entry # Time

001 8:00AM

002 8:04AM

003 8:08 AM


Does anyone else know how to create a form and have a button to run code to
do what im asking?
 
Back
Top