Search results

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

yes is the same when i entre expr1: Format([deb]; "yyyy/mm") the system gives expr1: Format([deb];"""yyyy""/mm") on the query createria

yes this is what i use expr1: Format([deb]; "yyyy/mm") but give just the result in the picture below

hello: i use this formula in an access query to get year/mounth and [deb] is my date field in the table expr1: Format([deb];"""yyyy""/mm") but when i execute the query i get the result shown in the picture below i use frensh windows and the language of my computer is frensh / format of deb field...

yes it work you are the best :)

one query for to get date of today and an other query to get date of yesterday