Search results for query: *

getting syntax errors trying to work them out lol will get back to you. thanks PHV

i did post the information from the tables listed above... the original tables are below: table 1: row name fault time 1. gas1 1 27/06/2011 15:40:35 2. gas1 1 27/06/2011 15:42:35 table 2: row name fault time 1. gas1 0 27/06/2011 15:41:35 2...

if you look at the time stamps there are duplicates. the original tables are below: table 1: gas1 1 27/06/2011 15:40:35 gas1 1 27/06/2011 15:42:35 table 2: gas1 0 27/06/2011 15:41:35 gas1 0 27/06/2011 15:43:35 the results of the query puts table 1 and 2 in same row...

just tried it still got 4 records results is below: Name Fault table1.timestamp Name Fault table2.timestamp sec gas1 1 27/06/2011 15:42:35 gas1 0 27/06/2011 15:41:35 -60 gas1 1 27/06/2011 15:40:35 gas1 0 27/06/2011 15:41:35 60 gas1 1 27/06/2011 15:42:35 gas1 0 27/06/2011...

SELECT table1.[Name], table1.[Fault], table1.[timestamp], table2.Name, table2.Fault, table2.timestamp, DateDiff('s',[table1].[timestamp],[table2].[timestamp]) AS sec FROM table1, table2;

Hi Andy thanks for looking at my post. in the query i pulled in both tables, and used sec: DateDiff('s',[table1].timestamp,[table2].timestamp) results are below: Name Fault table1.timestamp Name Fault Table2.timestamp sec gas1 1 27/06/2011 15:40:35 gas1 0 27/06/2011 15:41:35 60 gas1...

Hi there all I have 2 tables, table1 and the the other table2. They have the same fields: Name, Fault and timestamp I want to get the time difference from table1.timestamp to table2.timestamp I have tried running this a query but get duplication on data. wonder if anyone can help. Many...