SELECT [PermID] & [DateTimeLocal1] AS Key_ID_Date_Time, tbl_LotekIridium_temp.PermID AS CGD_PermID, tbl_Capture.CP_Sex AS CP_Sex, tbl_Capture.CP_RangeCode_Rels AS CGD_RangeCode, tbl_Capture.CP_GPSCol_SN AS CGD_GPSCol_SN, Left([DateTimeGMT1],8) AS Date_GMT, Right([DateTimeGMT1],8) AS Time_GMT, Mid([DateTimeGMT],7,4) & Left([DateTimeGMT],2) & Mid([DateTimeGMT],4,2) & " " & Right([DateTimeGMT],8) AS DateTimeGMT1, Left([DateTimeLocal1],8) AS Date_Local, Right([DateTimeLocal1],8) AS Time_Local, Mid([DateTimeLocal],7,4) & Left([DateTimeLocal],2) & Mid([DateTimeLocal],4,2) & " " & Right([DateTimeLocal],8) AS DateTimeLocal1, cutmn([latitude],[longitude]) AS UTM_N, cutme([latitude],[longitude]) AS UTM_E, tbl_LotekIridium_temp.Latitude, tbl_LotekIridium_temp.Longitude, tbl_LotekIridium_temp.Altitude, tbl_LotekIridium_temp.[Fix Status], tbl_LotekIridium_temp.DOP, tbl_LotekIridium_temp.TempC, tbl_LotekIridium_temp.MainV, tbl_LotekIridium_temp.BkupV
FROM tbl_Capture INNER JOIN tbl_LotekIridium_temp ON tbl_Capture.CP_GPSCol_SN = tbl_LotekIridium_temp.GPSCol_SN
WHERE (((tbl_LotekIridium_temp.Latitude) Is Not Null));