Relationships

[rhig]

Im having trouble with the query named overdue in my database, im trying to get the query to list car details with the loan return date as the output. I think its due to a mistake with my relationships but im not sure how to resolve it, if anyone has the answer I would be very gratefull for the solution.
Many Thanks,
Richard

http://tutor2u.mine.nu/access/carremake_Backup.mdb

 

[KevinM]

Your tables are wrong for a start.

You don't store the Return Date in the Loans Table.
You should calculate this using the DateAdd function based on the loan period.

You also don't store the total cost, again this is calculated in a query by simply multiplying the rate by the loan period.

Storing them in tables leaves it open to mistakes.

To find out which cars over due simply add <Date() in the criteria for the Return Date.

The query is also still showing an old field CarID (as a paramter) which I think you have changed with CarReg.