I am working on a database that keeps track of deployed and inventory of IP phones. I have 3 systems and I have a continuous form for each system system showing all configured IP phones. On each form I have command buttons to perform various functions. Two of these command buttons bring up a pop-up form. 1 for counts of phone types and the other counts of licences used.
Pop-up 2, License counts. I have 14 different licenses and 4 conditions to check for each license. My current pop-up has 61 control boxes, 15 four each condition which includes a total at the bottom and one control box to total all licenses with all control boxes using DCOUNT and checking 3 criteria; platform, license and condition. If 3 is to many to check I can build queries for each platform.
Example code:
Code:
=DCount("[platform]","qry_licenses_NonCare","[licenses]='I3_LICENSE_BASIC_STATION' and [cicstatus] = 'up-to-date'")
This all works great except for the delay when opening the form. I read on this forum that using an aggregate query would work better. I created one query that gives me the counts and now I am trying to get the correct formula in my control boxes.
I tried the following but get an error "#NAME?"
Code:
nz(=IIf([qry_licenses_reg]![platform]="non-care",iif([qry_licenses_reg]![licenses]="I3_ACCESS_ACD_MEDIA_1",[qry_licenses_reg]![countofcicstatus],"0"))
One more thing, a condition will not have a value for every license in that case I want to return a 0 value.
Any help or other suggestions on how to accomplish this task would be greatly appreciated.
Here is a partial screen shot of my pop-up forms.