Counter in a query with joined tables

[plus_stick]

Hi, everyone.
I've a query with joined tables in VBA to fill data in continious form.
And I want to make a dynamic Counter in it.

"SELECT cc_svod.kod_svod, cc_svod.datea, cc_svod.wave, cc_svod.CALL_ID, cc_svod.CALL_DATE, cc_svod.TOPIC1, cc_svod.TOPIC2, cc_svod.CLIENT_IIN, cc_svod.CLIENT_NAME, cc_svod.CLIENT_PHONE, cc_svod.CLIENT_LANGUAGE, cc_svod.operator, cc_svod.record_status, cc_info.c_status " & _
"FROM cc_svod LEFT JOIN cc_info ON cc_svod.kod_svod = cc_info.kod_info " & _
"WHERE cc_svod.operator = " & v & " AND " & _
"cc_svod.datea = " & Chr(35) & Replace(Format(Me.select_date.Value, "mm/d/yyyy"), ".", "/") & Chr(35) & " AND " & _
"cc_svod.wave = " & Me.select_wave.Value & " " & _
"ORDER BY cc_svod.CALL_ID "

How can I realize?
Thanx in advance.
PS. Method with DCount works very slow and shows incorrect counter.

[ranman256]

Dynamic counters can be iiffy. They can change as you look at them.
The easiest and reliable way is :
have an empty 'reporting' table with an autocounter, then copy the data to it.

the macro would:
copy the tRptTbl_MT to tRptTbl
append data to tRptTbl