Access help

[L?KE]

This is for my year 11 GCSE ICT project, which I am drastically behind on, lol.

Well anyway mine for a DVD shop, and there is a rentals table which takes the ID of the customer who made the rental and the ID of the product that is being rented.

I have a query that picks up all rentals that are maked as not returned, and the return date was 3 or more days ago.

How would I go about using the results from this query to grab the Customer and Product details based on the results returned from this query (i.e. the Product ID, Customer ID for each overdue item).

Below is an example result for the overdue products query:

So I want to get the details for the customer who's ID is 1 (in the above example)

[Jordy]

Hmm I've done that exact piece of coursework earlier this year, I'll bring it home from school tomorrow and you're welcome to a few queries if I can get it going again (I do my best to forget Access as it drives me mad).

[L?KE]

I would appreciate that very much

I'll PM you.