Assign Number

[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

 

[[MVP] S. Clark]

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Matt]

Each event is to be numbered each time, autonumber won't
work for this.

 

[[MVP] S. Clark]

VBA Code it is.

Each event is to be numbered each time, autonumber won't
work for this.