I have conquered creating a union with one query being designated as Top Level. I created another inner subquery with different data that I put in the Top Level to do some calculations. Problem is now I am getting a message that the number of columns do not match. Is Inner Subquery the wrong type to use or can it not be done since I have a union in there.
You need to put the subqueries in the correct order, and use parenthesis to group them appropriately.
1 Like
So here is what I have. I have added the Demand query to the top Level but still says number of fields do not match. Level 1 – Level 6 are all derived from SubQuery1
Dumb questions, So you brought the subquery into every single one of those levels right?
to check the field, go through each of the levels and look at right side of this grid, and look at the bottom bar. If you have all of the fields, that should be blank. If there is something in there, it’s looking for another field.
I think I know how to do it now. I need to add the demand to each level so that they all have the same number of columns. Trying that now.
Hmmmmm didn’t see that. Working on it now.
All of the “Next Field to Match” are blank. The number of records is correct.
Does it work without the sub queries in there?
Yes. What I did was add the Demand query to each of the level queries to get On-Hand and Demand so they are all even now and work.
From what I can see, it looks like it should be working to me. You’ll have to post some more screen shot’s to get more information for someone to help you.