i have a form named (TR Jours par Service) with two combobox (sc_cbo) for select services and (day_cbo) for select days of month and a query (Q_JM_select_TM) loaded from a table (t_rec).
i try to get number of records of one service in day (day_cbo) where i select sc_cbo and day_cbo
i try for many ways but no success
code : dcount("id_dec";"t_rec";"[sc_main] = Forms![TR jours par Service]![sc_cbo]")
please look to the picture below to know more
i try to get number of records of one service in day (day_cbo) where i select sc_cbo and day_cbo
i try for many ways but no success
code : dcount("id_dec";"t_rec";"[sc_main] = Forms![TR jours par Service]![sc_cbo]")
please look to the picture below to know more