<div>
You can use a UNION Query<br />
<br />
Select 'VideoCount', Count(*) As Quantity FROM VideoCount<br />
UNION<br />
Select 'CustCount', Count(*) As Quantity FROM Customer<br />
<br />
Cheers, Andrew
</div>


You can use a UNION Query

Select 'VideoCount', Count(*) As Quantity FROM VideoCount
UNION
Select 'CustCount', Count(*) As Quantity FROM Customer

Cheers, Andrew

<div>
Thanks so much TextReport. &nbsp;I used the second example you gave me. &nbsp;You've saved me hours worth of work, once again, thanks!
</div>


Thanks so much TextReport.  I used the second example you gave me.  You've saved me hours worth of work, once again, thanks!

<div>
<div class="content wysiwyg-content">
Is there any way we can get the total count of multiple tables with one sql statement? Something like this: <br />
<br />
Select count(Video_ID) As VideoCount, count(Customer_ID) As CustomerCount from Video, Customer <br />
<br />
Obviously this doesn't work, I was wondering if there was any correct way of doing this. I would appreciate any help. Thanks.
</div>
</div>


Is there any way we can get the total count of multiple tables with one sql statement? Something like this: 

Select count(Video_ID) As VideoCount, count(Customer_ID) As CustomerCount from Video, Customer 

Obviously this doesn't work, I was wondering if there was any correct way of doing this. I would appreciate any help. Thanks.

Getting the count of multiple tables with one SQL statement

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.