Need Help!

  • Thread starter Thread starter Russ via AccessMonster.com
  • Start date Start date
R

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?
 
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?
Click to expand...

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]
 
thanks and funny that you say that, he keeps showing me of examples in excel

John said:
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
Click to expand...
[quoted text clipped - 7 lines]
the spending by payee I acomplished with a crosstab query, no idea how to
insert projected info?
Click to expand...

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]
Click to expand...
 
Back
Top