Is Access/Jet Table is this:
id, wo,
1, 2345-1
2, 2345-1
3, 2345-1
4, 5432-1
5, 5432-1
6, 5432-1
Need result:
id, wo, parent
1, 2345-1, 1
2, 2345-1, 1
3, 2345-1, 2
4, 5432-1, 4
5, 5432-1, 4
6, 5432-1, 5
the logic is If wo = wo of ID-1 then Parent = Id-1
If wo not= wo of...
Am humble...need help w/ basic sql since I don't write it often enough
Sequence Rev SumPast4
1 100 n/a
2 110 n/a
3 105 n/a
4 103 418
5 55 373
6 90 353
etc etc
Table has first 2...
Have an sql puzzle that is so classical it could be text book.
Column1 is Date
Column2 is Amended Date
There is always an entry in Column1 - there is occasionally an entry in Column2.
My query needs to return the records in chronological order - and the Amended Date is to be used when it...
I enjoy sql - but sometimes can't get my head around the puzzle; Have Table1 due to sloppy data entry have duplicates in the Table1:
OrderID Name Address Email
1 Joe xxxx 123@test.com
2 Joe S. x xxx 123@test.com
3 Fred yyy 456@this.com
4 Jim zzz...
