Calculate available Assets at hand

[AIMIS]

Hi, I have a Software Assets Table (SAT), Hardware Assets Table (HAT) and Software Installed Table (SIT) which is a subform linked to the Hardware Asset tbl. When I purchase Software, I enter the qty in the SAT in a qtypurchased field and whenever I instal the Software on a hardware, I enter the quantity installed on the qtyInstalled field.

I would like to run a Report from a Query that shows "Available software" after calculating bought Software minus allocated software. Buying and installing software is an on-going process.

Kindly advise on a simple Query for beginners that I need to create.

[pbaldy]

Try 3 queries. A totals query that sums purchases by item, a totals query that totals installs by item, then a query on the items table (which I assume you have) with the first 2 queries joined in with LEFT JOIN.