Is there a way to expand the following SQL Statement to get a total record count using MS Access 2003 or do I need to perform another separate SELECT statement?
Is there a way to expand the following SQL Statement to get a total record count using MS Access 2003 or do I need to perform another separate SELECT statement?
SELECT Bank, count(*)
FROM tblOpenItems
GROUP BY bank;
SELECT Bank, count(*)
FROM tblOpenItems
GROUP BY bank;
jerryb30
Are you wanting a total count of records in tblOpenItems, or some type of running count?
ASKER
count of records in tblOpenItems
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
select bank, c, sum(c) from (
SELECT Bank, count(*) as c
FROM tblOpenItems
GROUP BY bank
)
SELECT Bank, count(*) as c
FROM tblOpenItems
GROUP BY bank
)
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.