I am trying to get the count of records from several queries into one query. This is the SQL from each of them:
SELECT Count(Q_Auth_Family_cnt.SSN) AS FamAuthCnt
FROM Q_Auth_Family_cnt;
SELECT Count(Q_Auth_MD_cnt.SSN) AS MDAuthCnt
FROM Q_Auth_MD_cnt;
SELECT Count(qryAuthToUpload.DSYID) AS PAAuthCnt
FROM qryAuthToUpload;
When I combine them into :
SELECT Count(Q_Auth_Family_cnt.SSN) AS FamAuthCnt
FROM Q_Auth_Family_cnt, Count(Q_Auth_MD_cnt.SSN) AS MDAuthCnt
FROM Q_Auth_MD_cnt, Count(qryAuthToUpload.DSYID) AS PAAuthCnt
FROM qryAuthToUpload;
I get a 'syntax error in from clause'.
Is there a way to do this from three different queries with no relationship?
Thanks,
Sup
SELECT Count(Q_Auth_Family_cnt.SSN) AS FamAuthCnt
FROM Q_Auth_Family_cnt;
SELECT Count(Q_Auth_MD_cnt.SSN) AS MDAuthCnt
FROM Q_Auth_MD_cnt;
SELECT Count(qryAuthToUpload.DSYID) AS PAAuthCnt
FROM qryAuthToUpload;
When I combine them into :
SELECT Count(Q_Auth_Family_cnt.SSN) AS FamAuthCnt
FROM Q_Auth_Family_cnt, Count(Q_Auth_MD_cnt.SSN) AS MDAuthCnt
FROM Q_Auth_MD_cnt, Count(qryAuthToUpload.DSYID) AS PAAuthCnt
FROM qryAuthToUpload;
I get a 'syntax error in from clause'.
Is there a way to do this from three different queries with no relationship?
Thanks,
Sup