G
Greg
Hello,
I am trying to create a query and can not get it correct!
I am trying to do a select query on one table using access 2000.
I am trying to look back one record in order to make a decision on the
record I am processing.
I am not highly skilled at SQL, so this may be trivial to some.
EXAMPLE:
Table:
1112223333,01/01/2006,James
1112223333,01/02/2006,James
1112223333,01/03/2006,James
1112223333,01/04/2006,James
1112223333,01/05/2006,James
4445556666,01/01/2006,Bob
4445556666,01/02/2006,Bob
4445556666,01/03/2006,Bob
4445556666,01/04/2006,Ralph
4445556666,01/05/2006,Ralph
7778889999,01/01/2006,Peter
7778889999,01/02/2006,Peter
7778889999,01/03/2006,Peter
7778889999,01/04/2006,Peter
7778889999,01/05/2006,Peter
In the above table I would like to extract the Ralph records and move all
the fields to the Dynaset(Output from Query). The logic for the selection is
that the Responsible person for account 4445556666 has changed.
Suggestions on how to do this are appreciated... But please remember I am
not an expert at SQL or VBA.
Greg
I am trying to create a query and can not get it correct!
I am trying to do a select query on one table using access 2000.
I am trying to look back one record in order to make a decision on the
record I am processing.
I am not highly skilled at SQL, so this may be trivial to some.
EXAMPLE:
Table:
1112223333,01/01/2006,James
1112223333,01/02/2006,James
1112223333,01/03/2006,James
1112223333,01/04/2006,James
1112223333,01/05/2006,James
4445556666,01/01/2006,Bob
4445556666,01/02/2006,Bob
4445556666,01/03/2006,Bob
4445556666,01/04/2006,Ralph
4445556666,01/05/2006,Ralph
7778889999,01/01/2006,Peter
7778889999,01/02/2006,Peter
7778889999,01/03/2006,Peter
7778889999,01/04/2006,Peter
7778889999,01/05/2006,Peter
In the above table I would like to extract the Ralph records and move all
the fields to the Dynaset(Output from Query). The logic for the selection is
that the Responsible person for account 4445556666 has changed.
Suggestions on how to do this are appreciated... But please remember I am
not an expert at SQL or VBA.
Greg