Actual / projected spending

  • Thread starter Russ via AccessMonster.com
  • 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?
 
R

Russ via AccessMonster.com

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help! 2
Query Corsstab with Three months roll over period 0
YTD average cust calulation 3
Group by Range in Crosstab Query 4
crosstab problem 2
Crosstab 5
Error: Cannot use the crosstab of a non-fixed column as a subquery 4
Date order in a crosstab query 2

Top