>
> I would like to get the total number of records for 2 tables combined.
>
> This is as far as I got:
>
> SELECT COUNT(*) FROM TBL1 UNION SELECT COUNT(*)
> FROM TBL2;
>
> This gives me 2 rows one with the number of records in TBL1 and one
> with the number of records in TBL2. How can I add these values?
>
> Regards
> William
>

YOu could create a view of this SQL statement then select the cum of your
count fields.
Alan