R
russtr
Guest
Im farely new to access so please bear with me.
Im working on creating a database to keep track of our software licenses for a small company
In my forms I have checkboxes setup for whether say Viruscan is installed on a PC. On form close I run an action query that populates my "viruscan numeric" field in the "main table" with 0 or 1 based on whether the checkbox value is YES or NO
I have another table, "licenses purchased" that has field "viruscan total purchased"
Now what I want to do is to have a report which would display
Sum of my "Viruscan numeric field"
and on the line below have that sum subtracted from "viruscan total purchased" to arrive at # of available licenses.
I'm pretty sure I can setup action queries that would do this for me but it would be a lot less complex to do right in a report.
Thanks in advance
Im working on creating a database to keep track of our software licenses for a small company
In my forms I have checkboxes setup for whether say Viruscan is installed on a PC. On form close I run an action query that populates my "viruscan numeric" field in the "main table" with 0 or 1 based on whether the checkbox value is YES or NO
I have another table, "licenses purchased" that has field "viruscan total purchased"
Now what I want to do is to have a report which would display
Sum of my "Viruscan numeric field"
and on the line below have that sum subtracted from "viruscan total purchased" to arrive at # of available licenses.
I'm pretty sure I can setup action queries that would do this for me but it would be a lot less complex to do right in a report.
Thanks in advance
