query of multiple queries

[proulxsa]

I am trying to run a query of multiple queries which will return the last date and hours logged since a certain part was serviced. I have individual queries set up to return the most recent service date/hour for each part (all return the most recent for that part). When I run a query based off of all the results, I don't get any records (I managed to get this to work once, but have no idea how). I think it has something to do with no one matching date, but the dates shouldn't match.

What I am ultimately trying to do is create a form which will calculate the next date/time a part should be serviced.

Thanks for any help, as I am learning Access as I go.

Sarah

 

[Courtman]

I'm also new to Access, but the way I've got around this (which if I'm wrong and doing this in the most cumbersome way ever - TELL ME SOMEONE!!!

) is to build a new query and query all the other queries and use "Group By". In the case of what I was doing I was looking at a number of totals in a logbook for different categories and then merging them all into one query at the end to display the results.

Hope this helps.


[This message has been edited by Courtman (edited 12-13-2001).]