Combine 2 seperate queries?

[ayupchap]

Hi there so after getting lots of help from this forum I am nearing the end of finishing one of my task that's been causing me a headache. If someone can solve this I would be so happy.



I now have a query which is finding people who during a certain date range are not wanting to board a bus so a report can be printed from this information, that's great. I also have a query that produces a list of people that normally get the bus which works great. Now how do I make a query that creates a report combining both those who can attend and those that can't so an overall list can be made?

I have two tables; Student and No_Bus. I would like somehow to show the normal bus report but add a comment saying NO BUS next to those who for that specific day can not get the bus, surely these queries can be combined in some way? and create a new field in a query saying NO bus if the NO BUS query is creating a report showing those that are not riding. Does this make sense?


Thanks so much

[AlexHedley]

A UNION might be useful here.

[ayupchap]

Will that allow me to keep all the fields of one table and attach the no buses to it? That's what I need I think?

[June7]

This is duplication of thread https://www.accessforums.net/databas...ain-40041.html