One more quick question, I need to do this for more than 1 column; can I do multiple SELECT's? I've tried to no avail... The ones I would require are...
Code:
SELECT
myTable.[Resp Time],
Int([Resp Time]) AS Expr2,
[Resp Time]-[Expr2] AS Expr3,
60*[Expr3] AS Expr4,
Round([Expr4],0) AS Expr5,
[Expr2] & ":" & [Expr5] AS Expr6
FROM
myTable;
Code:
SELECT
myTable.[Start Time],
Int([Start Time]) AS Expr2,
[Start Time]-[Expr2] AS Expr3,
60*[Expr3] AS Expr4,
Round([Expr4],0) AS Expr5,
[Expr2] & ":" & [Expr5] AS Expr6
FROM
myTable;
Code:
SELECT
myTable.[Fix Time],
Int([Fix Time]) AS Expr2,
[Fix Time]-[Expr2] AS Expr3,
60*[Expr3] AS Expr4,
Round([Expr4],0) AS Expr5,
[Expr2] & ":" & [Expr5] AS Expr6
FROM
myTable;
Can you help me