Recent content by ryprobg

anyone help please!!!!!!!!!!!!!

how i can make the somme of count (CompteDeNR) by service maintenance and by date and SommeDeTR like this : * atelier Bull et camions : 20/09/2022 | ( 1+1+1) | (4.19 +3+5.3) * atelier Electrique Engins : 20/09/2022 | ( 1+1) | (5.19 +2) * station service : 20/09/2022 | (1) | (0) * atelier Bull...

hello need a quick help to grouping (service maintenancier) in this query by geting (somme of NB service) once time this is the maximun value of dcount for (service maintenancier).. the meaning is to groupnig each (service maintenancier) with there (somme of nb TR) exemple : Atelier Bulls et...

anyone know solution?

can you help me Gasman :)

NR: dcount("*","t_rec","[sc_main] = '[Forms]![TR jours par Service]![sc_cbo]" and "[deb]>=date()'") but the problem the result is the total number of records not number of records of today [deb] is my date field

i can simple all of this : how i can get number of (sc_main) recodrs with select (sc_cbo) and today date how i cant get it..i mean two createria in dcount function

SELECT t_rec.nature, t_rec.sc_main, Format(Val(Day([deb])),"00") AS [jours rec], DCount("*","t_rec","[sc_main] ='" & [Forms]![TR jours par Service]![sc_cbo] & "'") AS NR, Month([deb]) AS Expr1, Format(Val(Month([deb])),"00") AS Expr1, Sum(DateDiff('h',[deb],[fin])) AS TR FROM t_rec GROUP BY...

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 selected day (day_cbo) when i select sc_cbo and day_cbo i...

thank you for your anser; the problem here is i want to get number of records (sc_main) in one day whene i select the combobox of days (day_cbo) in the selected date , you should know that day_cbo is a numeric field

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...

hahahahahaha yes glued by iron in my brain hahahaha

resolved!

no in frensh windows ; replace ,

the same problem result yyyy/09