J
John de Beer
Good Morning from San Diego
I have 2 tables. Table 1 has a list of processing events and values
including Controller, Date, Time, cyclenumber, and other values.
There are many values collected per cycle and the cycle extends past
midnite. A new cycle starts at 1 on the first cycle of the new day,
so if there was only 1 cycle on day one, and it extended past midnite,
and a new cycle starts on day 2 it will also have the same cycle
number.
I need to assign a unique cycle index to each value in table 1 so I
have created a table (Table 2) with a cycle index based on a unique
event. This table also includes Controller, cyclenumber, the start
date and start time for each cycle and the finish date and time for
each cycle.
I want to assign the correct cycle to each record in table 1.
Can this be done with a query or must I write VBA code to make these
assignments.
Thanks
jdb
I have 2 tables. Table 1 has a list of processing events and values
including Controller, Date, Time, cyclenumber, and other values.
There are many values collected per cycle and the cycle extends past
midnite. A new cycle starts at 1 on the first cycle of the new day,
so if there was only 1 cycle on day one, and it extended past midnite,
and a new cycle starts on day 2 it will also have the same cycle
number.
I need to assign a unique cycle index to each value in table 1 so I
have created a table (Table 2) with a cycle index based on a unique
event. This table also includes Controller, cyclenumber, the start
date and start time for each cycle and the finish date and time for
each cycle.
I want to assign the correct cycle to each record in table 1.
Can this be done with a query or must I write VBA code to make these
assignments.
Thanks
jdb