Link to home
Start Free TrialLog in
Avatar of DominicConstable
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.



ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DominicConstable
DominicConstable

ASKER

perfect solution