Filter data

[astridhg]

I have a db where showing rental of different items.

In the rental form the users selects the period they want to rent items for. When doing this I would like that when the user is to pick out items to rent I would only want the items that is not rented for selected rental period to show.

Any easy way of doing this?

 

[danvlas]

Well... create a query to display all items that are rented for the period, then left join items table to that query and set the condition 'Query.ItemID Is Null'

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html