count in select query

[jslssuze]

I created a database with registration information and my query works well on simply the count of people registered. Instead of count, however, my clients wants number of spaces available (i.e. 10-count)... how do I write that query?

Thanks!!!!!

[JConsulting]

I created a database with registration information and my query works well on simply the count of people registered. Instead of count, however, my clients wants number of spaces available (i.e. 10-count)... how do I write that query?

Thanks!!!!!

Can you post your SQL for your query here?
J

[jslssuze]

I created a database with registration information and my query works well on simply the count of people registered. Instead of count, however, my clients wants number of spaces available (i.e. 10-count)... how do I write that query?

Thanks!!!!!

This is what the SQL query looks like now

SELECT DISTINCTROW Count(Results.[Webinars_Computer-Basics]) AS [CountOfWebinars_Computer-Basics], Count(Results.[Webinars_Introduction-to-TASBiller]) AS [CountOfWebinars_Introduction-to-TASBiller], Count(Results.[Webinars_Mystery-Behind-the-Numbers]) AS [CountOfWebinars_Mystery-Behind-the-Numbers], Count(Results.[Webinars_Custom-Invoices]) AS [CountOfWebinars_Custom-Invoices]
FROM Results;

[MMcCarthy]

This is what the SQL query looks like now

SELECT DISTINCTROW Count(Results.[Webinars_Computer-Basics]) AS [CountOfWebinars_Computer-Basics], Count(Results.[Webinars_Introduction-to-TASBiller]) AS [CountOfWebinars_Introduction-to-TASBiller], Count(Results.[Webinars_Mystery-Behind-the-Numbers]) AS [CountOfWebinars_Mystery-Behind-the-Numbers], Count(Results.[Webinars_Custom-Invoices]) AS [CountOfWebinars_Custom-Invoices]
FROM Results;

Just try ...

SELECT 10 - Count(Results.[Webinars_Computer-Basics]) AS [Webinars_Computer-Basics_Available], 
10 - Count(Results.[Webinars_Introduction-to-TASBiller]) AS [Webinars_Introduction-to-TASBiller_Available], 
10 - Count(Results.[Webinars_Mystery-Behind-the-Numbers]) AS [Webinars_Mystery-Behind-the-Numbers_Available], 
10 - Count(Results.[Webinars_Custom-Invoices]) AS [Webinars_Custom-Invoices_Available]
FROM Results;

[JConsulting]

Looks good to me. Do you expect to handle any negative numbers?

[jslssuze]

Looks good to me. Do you expect to handle any negative numbers?

It worked great! I don't know if there will be negative numbers.. only if someone registers when the numbers are showing 0