Re: Query for comparison of totals

What happened to the field named TheYear?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"subs" <subbu1678@xxxxxxxxx> wrote in message
news:944fa9ce-d6d5-4be0-8c61-ac5d4fdbe573@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Feb 28, 10:58 pm, "Allen Browne" <AllenBro...@xxxxxxxxxxxxxx>
wrote:
Why are they repeated 2ce?
Is this for the 2 years?
Do you need to add criteria to the 2nd stage query to limit it to this
year's figures only?

Ultimately, you will have to do your own debugging.
We can only suggest approaches for your to investigate.

"subs" <subbu1...@xxxxxxxxx> wrote in message

news:bbc43390-2d58-499d-9ab5-6eb449f56f60@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Feb 28, 9:55 pm, "Allen Browne" <AllenBro...@xxxxxxxxxxxxxx> wrote:
i looked at your query- it is not giving the desired results- the
origin st and city are repeated twice. i.e there are two rows are
being shown in the output. Can you please help

for the above example that i have posted originially- i am getting the
following output after all your steps
ost ocity sum2008 sum2007
A B 7908 778
A B 778 7908

As you could see there are two rows and the sums are getting
interchanged- the output should have the second row only- can you tell
me what i am doing wrong/ pl help
.

Relevant Pages
Quantcast