Whenever I try to open this query, Access starts "Not Responding" every time...any ideas as to why? Here is the SQL for the query...seems like such a simple query to mess up the DB
SELECT Query3.ID, Query3.[Card Number], Query3.Mileage, [Mileage of Previous ID].Mileage AS [Previous Mileage]
FROM [Mileage of Previous ID] INNER JOIN Query3 ON [Mileage of Previous ID].[Previous ID] = Query3.[Previous ID];