Where is the supposed Union tab?

CanvasShoes

Registered User.
Local time
Today, 15:31
Joined
Sep 25, 2009
Messages
25
So here are the instructions from MS on one of their pages

Combine the select queries in SQL view


  1. On the Create tab, in the Queries group, click Query Design.
    A new query opens in Design view.
  2. Close the Show Table dialog box.
  3. On the Design tab, in the Query group, click Union.
Nice, only where in blue blazes is the Query group? After I close the show table dialog box, as instructed, I'm left with nothing but the design view of the query. I'm using Access 2010.
 
see attached jpg
 

Attachments

  • QueryDesign.JPG
    QueryDesign.JPG
    65.9 KB · Views: 92
see attached jpg
ARGH! The way they describe it, it seems as if they're talking about the query design section. Of course that was after a whole day spend trying to solve a cranky query and using ancient eyes on a tiny laptop computer screen.

Thanks so much for pointing it out.

I am having trouble with two fairly simple queries, so maybe I don't need to do a union after all, but for the life of me I can't think of how to solve this problem, or the right way to word a google search to find the answer.

I have tables with different materials that I've summed based on the supplier and then the type of material. There is a main table grouped by supplier and then the materials are summed by weight.

The second query groups by supplier and then sums weight of a specific type of material. What I want my end product to be is a table that is grouped by suppliers and has a column for all materials totaled by weight and then another just the one type of material summed by weight. Basically a large delivery of materials was made on one day, and I'm trying to split it out by type but still show the overall total.

Anyway, I did a third query joining the first two to do a comparison. It works perfectly, other than the fact that it only returns records that have both all materials and the one type of material. It ignores all of the records that are only totals. There should be approximately 200 records but it's only returning the 60 or so that have both Material A and All Materials (not the names of the headings, they're more like "NETWTALL" and "NETWTGRN"), just as an example.

I hope that makes sense?

thanks!
 

Users who are viewing this thread

Back
Top Bottom