2 list result query!

[tonycl69]

Hi everyone, I have had a look at similar threads but not quite what I am looking for hopefully someone has come accross this before and can help.
Heres the thing.
I have designed a vehicle maintenance database, I have a query listing vehicle tests due between 2 dates from a form. This works fine, what I would like to do is also show the same list but with a list on the same report those that have been tested along side those that have. I have 2 tables, tblmain which holds the vehicle details and when the test is due and another table thats holds work carried out on the vehicles which includes when the test was done. Hope this makes sense not easy writing it out like this. Cheers

 

[jdraw]

There is a free data model for vehicle maintenance at
http://www.databaseanswers.org/data...maintenance_with_attributes_print_version.htm

It may be useful to review your table set up. It is a generalized model and parts may not apply to your application.

 

[tonycl69]

I will take a look

 

[tonycl69]

Looks ok but mine is quite a bit more involved but I see your point, that is more to do with the maintenance, we are similar to a hire company within the main company we do all maintenance, testing, servicing, we have a fleet of vehicles so need to know whos driving where it is in the contry etc. But thanks

 

[jdraw]

Perhaps you could show us your tables and relationships as a jpg.

 

[tonycl69]

Ok here goes, there are duplicates in the tblmain which are redundant, they will be deleted soon. I started this about 4 years ago, and have been picking up tips along the way so this is partly an evolution of sorts.