Search results

Thank you to both of you for your ideas, the above query worked perfectly. Thanks, M

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...

I've solved the "before" "after" problem using: IIf([501 All TQ Before After Action.Period] = "before" ,"Track car","Track car") Still not sure what to do about the "ID" instead of Work ID

I've tried what I think you are suggesting but it doesn't give the desired solution. Here is what I've tried: SELECT [501 All Before After Action].WorkID, [501 All Before After Action].[Work Type] AS Maintenance, [501 All Before After Action].[Work Date] AS [Date] FROM [501 All Before After...

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 --...