Assign Number

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I'm creating a scheduling DB where each event will have
multiple parts. I'm trying to have a number automatically
assigned to a time, for use in a summary report for each
scheduled event.
For instance:
Event A has three parts, one @ 7am, one @ 10am and another
@ 12pm.
I want to have a summary showing 7am numbered 1, 10am as
2, and 12pm as 3.
If a new part should be added at say 9am: 7am would stay
1, 9am would be assigned 2, 10am would change to 3 and
12pm would become 4.

On the summary report, the parts of each event, would be
listed as below:

Action # Start Time Action
1 7am Description of Action
2 9am ""
3 10am ""
4 12pm ""

Each scheduled event would have its own set of numbers
assigned to its individual parts.

Thanks,
Matt
 
Does each event have to have 1, 2, 3, etc, or can the numbering of each time
continue sequentially such that
a 1, 2, 3
b 4, 5, 6
c 7, 8, 9
??

If so, then it's easily solved using an autonumber in a child table.
If not, then you'll need to write some code to take care of the numbering of
the time.

The report is easy from there.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top