Query calculations off other queries

[CT_AccessHelp]

I have the query below that I need to do a calculation against. I need each practice acres to subtract off it's allocation. Can't figure it out , it's been a looooong week and I'm so over this database LOL TGIF!








End result needs to be something like this:

Practice	Acres by Practice	Allocation	Acres left in Allocation
CP23	17994	20000	2006
CP23A	25	5000	4975
CP27	2567	8000	5433
CP28	111	500	389

[pbaldy]

Presuming there's a table with the allocation for each practice, you should be able to join that table to the query and add that field to the results, enabling you to do math with it.

[CT_AccessHelp]

Presuming there's a table with the allocation for each practice, you should be able to join that table to the query and add that field to the results, enabling you to do math with it.

Yes, Thanks! I was fried on Friday, got it.

[pbaldy]

Happy to help!