Combining quieris

[cmiyatake]

How can I combine queries to gather common data from each query into a single datasheet? I have 3 queries that share common fields (i.e. IP address, hostname, role, issue). What I am seeking is to combine the three queries based on specific issues then combine them to see how many IP's share all or some of the issues.

[Micron]

I have 3 queries that share common fields (i.e. IP address, hostname, role, issue)

Based in that comment, see if a UNION query will provide what you need.

[cmiyatake]

I'll give it a go

[cmiyatake]

found a gliche. I don't have SQL experience. Seems to require SQL notations to make a Union Query

[JoeM]

found a gliche. I don't have SQL experience. Seems to require SQL notations to make a Union Query

Actually, you don't. Just do the following.

1. Set up your three queries so that they al return the same number of fields in the same order.
2. Go to each query, change the View to "SQL View" and copy and paste the SQL code it shows you (this is the SQL Code of the query you just built!).
3. Start a new query, switch to "SQL View", and paste the SQL code from the first query you copied.
4. Delete the semi-colon ( at the end of the SQL code.
5. At the end, type " UNION " (note the spaces on both sides of the word UNION)
6. Paste the SQL Code from the second query you copied after that.
7. Repeat steps 4-6 and add the code from the third query.
8. View your results

So, by doing that, you will be able to create a UNION query without having to knowi how to write SQL code.

[orange]

Info on Union query