count in select query

Originally Posted by 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!!!!!

Originally Posted by 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!!!!!

Originally Posted by jslssuze

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;

Originally Posted by JConsulting

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