need help with expressions

cyr0n_k0r

New member
Local time
Today, 01:40
Joined
Mar 30, 2005
Messages
8
Ok. I am building a software inventory database. We need to be able to input data tables for each serial number of a certain program. The problem I am having is tyeing-in information from a query and spitting it out in a text field. (Please keep in mind I have only been working with Access for 2 days, so if you explain something please give me a step by step)


Visual is much better.

window.jpg


What I need to do is take the TOTAL count of all liscense currently being used in each subform (it's tied to software ID) and add them together to bring a total and display it in the "Licenses in Use" field.

I then need to take the TOTAL count of all the liscenses that are remaining and spit that out into the "# Available" field.

They need to be able to change as new records are added or removed. If I add a new serial number to the list, and it's not going to be in use.. then # Available field needs to increase by one.

Here is the query that I have setup (I think it's right) but as of right now I am not sure what I am doing. Any help would be great.

query.jpg


since I dont know how to add totals of checkboxes that state whether or not its available right now the query is counting the number of "Issuer". the blank issuer is the one that has all the available serials.
 
in order to add totals, all you have to do is while you are at the design view of your query click on the sigma symbol, to get a new row (Total Row), then you can select the sum function for the field in question to add you total.
 
Im not really understanding what you just said. Another poster on another forum suggested this... but I have idea how to implement it.

create a group by (totals) query with the following fields

product name - group by

InUse: iif([in use]=true,1,0) - sum

Available: available: iif([in use]=true,0,1) - sum
 

Users who are viewing this thread

Back
Top Bottom