Search results

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 !

hey guys ! every time i add new employee's data it also saves all SiteTitles (8) times all trainers (3) and i get 24 records. not really sure what i set up incorrectly. i checked everything and nothing found. here is the db. it should open main menu nav. click on "add training". add basic...

will do ! thank you very much !

@Edgar_ not sure if its related to your code, but every time i add new employee's data it also saves all SiteTitles under current ID. how it works now. i select customer then siteTitle, add few other related into and it saves the same employee under all SiteTitles which are in the list hm...

rates - its just rating from 1 to 5 for 8 feedback questions like. rateID=1 is "overall how do u feel about it" 1 2 3 4 5 rateID=2 is "rate education materials" 1 2 3 rateID=3 is "have u learn something new today" yes or no, but i prefer keep it 0 or 1 / 1 or 2 rateID=4 is "have u *****" 1 2 3...

thank you guys @theDBguy and @CJ_London for your help !