Query Help

W

Welthey

I need some help with a query that I am trying to create. I have 2 table
that hold a time field.
SELECT tbl_Sears_FAD_File_MinTime_Date.FFSL_ACCOUNT_NUMBER
FROM tbl_Sears_FAD_File_MinTime_Date INNER JOIN
tbl_Sears_FDR_Dec07_ClientDefined ON
(tbl_Sears_FAD_File_MinTime_Date.AUTHDATE =
tbl_Sears_FDR_Dec07_ClientDefined.[Action Date]) AND
(tbl_Sears_FAD_File_MinTime_Date.FFSL_ACCOUNT_NUMBER =
tbl_Sears_FDR_Dec07_ClientDefined.Account);

I need to find out the time difference between the time in my FAD file and
the time in my FDR file. The account and date information should be the same
in both tables that that is why I used it as a link.

Can someone please advise where I should go from here.
 
Top