dcount - several criterias

M

marcello

Hi,

My problem could be sum up as following :
I have 2 tables :
- records : it lists records with only 2 fields, an id (id_records) and a
value date (value_date_records).
- statistics : it displays statitiscs based on value date. Two fields :
total records (total_records_stat) and value date (value_date_stat)

I want to produce statistics, i.e. to count how many records I have in my
table records for a specific value date. For instance, how many issues I have
value date 24/12/03, 25/12/03, …


I try to use an update query, with a DCOUNT formula. I update my field
total_records_stat of statistics with the following formula :

DCOUNT(“[id_records]â€,â€recordsâ€,â€[records]![value_date_records]=[statistics]![value_date_stat]â€)

But it doesn’t work, I got zero. Could you please help me.

Marcelllo
 
Top