Need Help!

[Russ via AccessMonster.com]

Ok, I have a picky boss who is asking me to make a query that will show all
spending by payee and also show project spending in same query. Is this even
possible? The estimated number is a number he want to plug in, not a
calculated number.

Example;
Payee Jan Feb Mar.... June (Estimated)
Ace Hardware 30.00 40.00 25.00 31.66

the spending by payee I acomplished with a crosstab query, no idea how to
insert projected info?

 

[John Vinson]

Ok, I have a picky boss who is asking me to make a query that will show all
spending by payee and also show project spending in same query. Is this even
possible? The estimated number is a number he want to plug in, not a
calculated number.

Example;
Payee Jan Feb Mar.... June (Estimated)
Ace Hardware 30.00 40.00 25.00 31.66

the spending by payee I acomplished with a crosstab query, no idea how to
insert projected info?

Possibly by basing the Crosstab query on a UNION query, unioning data
from a table of spending and a separate table of estimates... but we
know NOTHING about the structure of your data or where you're working
from, so it's hard to say.

Frankly this sounds like an application that might be better done in
Excel. "Horses for courses..."

John W. Vinson[MVP]

 

[Russ via AccessMonster.com]

thanks and funny that you say that, he keeps showing me of examples in excel

Ok, I have a picky boss who is asking me to make a query that will show all
spending by payee and also show project spending in same query. Is this even

[quoted text clipped - 7 lines]

the spending by payee I acomplished with a crosstab query, no idea how to
insert projected info?

Possibly by basing the Crosstab query on a UNION query, unioning data
from a table of spending and a separate table of estimates... but we
know NOTHING about the structure of your data or where you're working
from, so it's hard to say.

Frankly this sounds like an application that might be better done in
Excel. "Horses for courses..."

John W. Vinson[MVP]