We are just an advanced breed of monkeys on a minor planet of a very average star. But we can understand the Universe. That makes us something very special.
I have a table of Shape Areas with fields for different shapes and a specific area assigned to each shape. And a second table that is Puzzle Area, with fields shape 1, # 0f shape 1s, shape 2, # of shape 2s etc. I'm trying to write a query to calculate the total area of the puzzle. Prior to the calculation part, the query I tried only returns the area of the first shape 1 for all shapes. Is it possible to write a single query that pulls each different area for each different shape? (Without having to write separate querys for each separate shape in the puzzle?)
Kevin Yip
@Reply 3 years ago
You can drag the same table multiple times into the query, and Access will name them "_1", "_2", and so on. You can join them as if they were different tables. See picture below.
Kevin Yip
@Reply 3 years ago
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
