Matt Lemon
|
| Posted: 03/21/2003, 3:36 AM |
|
Hi,
I have a DB that tracks the software licences of my company and the PC's that they are installed on. There is a table that holds the software info and another that holds the pc numbers that software is installed on along with the ID of the software.
I have a field that gives the number of licences we have and I want to show the number remaining for use  I could add a field for the number used but I'd rather just go through the second table and count the number of times that a software ID appears and subtract that from the number purchased. I know what the SQL statement would be but not how to incorporate that into CCS.
Any pointers ?
Matt
|
|
|
 |
Matt Lemon
|
| Posted: 03/21/2003, 4:15 AM |
|
OK,
I have created a form and have the source type set as SQL with the data source set as an SQL statement as follows :
SELECT COUNT(softwareid) AS 'Num of installs'
FROM installed
WHERE softwareid = 'swid'
The problem I now have is that I want 'swid' to be the value passed in on a URL. Any idea how I use a URL parameter here ?
Matt
|
|
|
|
|
