Hi,

I need help solving this. I am running this query in MAccess.

Table : TankGaugingDB(TimeRecorded as Timestamp,DataX as Integer)
Table : InduDB(TimeStart as DateTime,TimeStop as DateTime)
Code:
SELECT     
InduDB.TimeStart, InduDB.TimeStop, TankGaugingDB_1.DataX, TankGaugingDB.DataX AS Expr3,
TankGaugingDB.DataX + TankGaugingDB_1.DataX AS Tank_Gauging, 
FROM         
((InduDB INNER JOIN
TankGaugingDB ON InduDB.TimeStart = TankGaugingDB.TimeRecorded) INNER JOIN
TankGaugingDB AS TankGaugingDB_1 ON InduDB.TimeStop = TankGaugingDB_1.TimeRecorded)
The issues:

1) The TimeRecorded is store as MSQL timestamp which e.g "2005-09-18 10:00:00" where as the TimeStart and TimeStop is store in MAccess with datetime datatype. Is it possible to query using the query above?

2) Also as both the table are populated by different application the (TimeStart,TimeStop) and (TimeRecorded) will not be exact by the second. So my question is can this query work?
Please advice.