Actual / projected spending

  • 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?
 
please help!
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...
 
Back
Top