Search results

Hi arnel, this is my sample db with picture of desired report to be made for info, when form ypovolesfrm opens, we select year, month and a team, (BARDIA) then we click on plan and a crosstab opens. It's column heading for info, is a concarnation of month date, date name initial and shift for...

Thank you i shall try that

hello i would like some help, have this crosstab query QrPlanCross, with TRANSFORM Max(QrPlan.EidYpirSynt) AS MaxOfEidYpirSynt SELECT QrPlan.Epitheto, QrPlan.[A/A], Max(QrPlan.eidosypiresiasID) AS [Total Of eidosypiresiasID] FROM QrPlan GROUP BY QrPlan.Epitheto, QrPlan.[A/A] ORDER BY...

Arnel made some tests before adopring your sample DB and with years and months and i found that it is working eg for year 2022 , month 11th, and next month 12th, it is ok for shifts and teams.. but if gong to month 10 same year, shift for team 1 should be afternoon not rest and so on its...

Arnel it is great. I shall try to match information with greeklish named fields and go on to report build. Thank you ALL

Another question. suppose i need not to raise blud preasure Is there a way ebs17, Doc_Man in your query to include code so it shall listen to parameters from form a) for year like 2022, 2023 etc and b) for month like selected 1,2,3, etc from my form, so query not only produce shifts for teams...

ebs17 one small favour i noticed query fails to produce first day of a given month do you confirm that? oh no its not i must had seen wrong

The approach is great. I am trying to combine combine your query with my append query for my goal and that is tricky too..

ebs17, because here knowledge is slow coming could i replace it with my dayofmonthtbl which excists already? it was made on same purpose i suppose

Thank you! i saw it and it warks fine as to Doc_Man solution need to ask what is table T999, what is its purpose.. question generated after the fact i've never seen query made inside of query ..

Thank you for the solution, and to admit yours is the one working for me no more complexity was needed for there was already a table with a field DD with numbers in there from 1 to 31 and with dateserial function and parameters from a form i was able to append field to teams for each day of a...

Thank you and excuse me for not reporting my level of code proficiency. For that its primitive in comparison with yours i suppose. I think people work in teams and irrelevant from personal duties name holidays etc their teams always work. If it wasnt so it would not be a shift covering 24/7 as...

hello, i am trying to accomplish this in work there are 5 groups or teams working each day and weekends, in 5 different shifts (eg morning, afternoon, night, rest,day off). like in this example TeamShiftstbl ID teamID DateParam shift 1 1 1/11/2022 Night 2 2 1/11/2022 Rest 3 3...

Thank you i shall try your solutions. To not be misadrestood in my first post first code is sql from an insert query witch without need of a select query produces the result. All i wanted was code on click of a button to update the records with the parameters from month and year based on that...

hello arnelgp same again too few parameters

cant find the field |1 in expression Arnel in touch later have to pick up kid

Same problem arnelgp too few parameters

Yes they are.

Hi, as i am unfamiliar with VBA i need help with code on this purpose i 've designed a form with a button to insert records in a table which has a date column. When run from my query it is doing the inserts as expected (inserts as many dates in rows as month dates excist in calendar because...

took the idea from this post as i think it suits my needs https://www.access-programmers.co.uk/forums/threads/employee-duty-work-database.222317/#post-1544755 but instead i dont wanna use people but 5 groups of people and my shifts are 5