Field Auto Change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

In a QUERY I am trying to make a field look up a so that if some of the
fields in the same row are equal than it will give the same field listed in
the equal row. For example: if field [Stop] =2 than look up in the same row
the field [Dock] and compare it to the rest of the sheet and if it finds a
match than look up the field [Turn] and if that matches as well than clone
the field [Time] in to the [Time] field of the [Stop] row that equaled 2.

Further example:

BEFORE:
[Dock] [Turn] [Stop] [Time]
122 1 1 06:00
142 1 1 05:00
122 1 2 09:00

AFTER:
[Dock] [Turn] [Stop] [Time]
*122 *1 1 06:00
142 1 1 05:00
*122 *1 2 *06:00*


Is there a way to do this?

Thanks for all your help,

Cage
 
One way is to use two queries and a form/suborm not linked Master/Child.

The second query get it's criteria from the main form text box and when the
text box is double-clicked have it refresh the second query.
 
Back
Top