DominicConstable
asked on
Access 2007 record count
I have queries that count the number of records in 3 files, E1, E2, E3
I use
NumRecordsE1: Format(CStr(Count([TalxE1] ![YEAR])), "0000000")
NumRecordsE2: Format(CStr(Count([TalxE2] ![YEAR])), "0000000")
NumRecordsE3: Format(CStr(Count([TalxE3] ![YEAR])), "0000000")
I need to put these record counts into another table called Z1 with 4 fields:
Z1, E1 count, E2 Count, E3 Count
I know I can append each query but that leaves me with 3 records. One for each. I only need one record with the counts.
I use
NumRecordsE1: Format(CStr(Count([TalxE1]
NumRecordsE2: Format(CStr(Count([TalxE2]
NumRecordsE3: Format(CStr(Count([TalxE3]
I need to put these record counts into another table called Z1 with 4 fields:
Z1, E1 count, E2 Count, E3 Count
I know I can append each query but that leaves me with 3 records. One for each. I only need one record with the counts.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER