Recent content by TipsyWolf

then i have to add - we have a middle name as well. its father's name and its very much important for us as name itself :)

no worries, im already thankful that u decided to help me. no time barriers wouldn't it easier to just input FullName and JobTitle to input field ?or is it the same ... , just confused with "registration"

no no

sorry, my bad. next time i will do threads more detailed. thanks :)

thank you for your response. i didn't get how to implement your solution, but i found this FROM Employees AS e2 WHERE e2.TrainingAttendanceID_FK = e.TrainingAttendanceID_FK AND e2.EmployeeID <= e.EmployeeID) AS RowNumber and it worked for me. thank you anyway !

hello everyone ! i have a query with sql TRANSFORM First(IIf(r.QResponse=q.CorrectResponse,"✓","✘")) AS ResponseResult SELECT e.TrainingAttendanceID_FK, e.EmployeeID, e.FullName, e.JobTitle, DCount("[EmployeeID]","[Employees]","[EmployeeID]<=" & [e].[EmployeeID]) AS RowNum...

oh, okay, i was right then, just wanted to make sure. nice ! :)

cant wait ! :) select ? we dont have full emp list for every customer. i get attendance list just 1 day or sometimes just 1 min before training, so it would be great if i need to manually type each employee (or paste it) into form after i select cusotmer, customerSite, trainingtype, trainer...

btw, while u r helping me, im trying new designs for myself. kinda practicing and another reason is to find out .. could i build this db if not you, who grateful decided to help me out here. i learn something new day by day. very slow, but still something. UPD: this design is bad and wrong

could u please add timestamp for it ? isn't too much ? another angle is simplicity though and not to brake it later. what if i click "generate certificates" twice. is it gonna re-write timestamp data ? so think timestamp isn't necessary. well, i think i could play around with it later, so...

we dont have training fees. its legal department contracts etc. we dont see it, we dont touch it. maybe later i would like to have something to calc $ per trained emp or per trainer or similar, but for now i would prefer to keep it without contracts as i dont have any info about it right now. i...

no, they are not yes, its me who input the actual rating. i made pdf file to be attached to every training session, so wont be a problem to do random checks if someone decided to hide things like bad \ average rating. no. its solo trainings.

thanks you for your reply. now i understand my mistake. im missing attendee table \ training session which @LarryE designed the structure properly in his version. im gonna need to re-build half of what i did with dozens hours on UI. im not sure what i would do without AWF...

@LarryE , Sir not sure if i already mentioned, guess i didn't, but i found an option to save \ store pdf outside of the db. so dont spend your time on it. deepseek helped me with it. once again - thank you for your time !