Search results
-
M
Help with a query involving duplicates
Hi I'm struggling with the following query, if I'm honest I'm not sure where to start with it: Original table: |Poskey|Date | Action| |1 |05/06/2011|Ballast | |1 |05/06/2011|Sleeper| |1 |05/06/2011|Rail | |1 |23/02/2009|Ballast | |2... -
M
Combining two columns
Could somebody please help me with a problem I'm having. I think it will be easier if I draw what I would like to do with my database: I have two tables: [WorkID]-[Period]-[TrackcarDate]--[SD]--[Lat] -- 1409 --- Bef ---- 07-Jan-05 ---- 2.1 -- 0.8 -- 1409 --- Aft ---- 27-Apr-06 ---- 1.2 --...