Recent content by pigkachu

This is the system i am currently doing. As you can see from the due survey tab. there is duplicate record due to the person have different course name. I only need the name to appear one time based on the earliest date the person take the course

I am quite new to the system. Do you mind providing some example so i can understand what you mean >.<

Hi llkhoutx, Thanks for the reply! So i need to create another query design to group duplicate rows? For the result display, i actually don't mind not showing all the courses the trainee attend. I just need the query to display 1 record for the person regardless of what course they taken

Hi, i have a question on hiding duplication record using query. The fields in the query are: full name(trainee), NRIC(trainee), gender(trainee), preferred language(trainee), company(trainee), course name(course), course date(course), competent(course), class(course), L3 survey(trainee), L4...

Hi can you give me an example? Thanks :D

Hi Solo712, thanks for the reply! Somehow the insert is able to work even though the date is in string. But i guess i shall change it to date format to prevent future error. Thanks! :)

Thanks Solo712.. :D It's already solved

Hi marlan, It's already in expression mode.

Hi marlan, Thanks for the reply i tried nested IIF function example: IIf([Sumofcount_core]>=7 And [Sumofcount_elective]>=3,IIF([RESULT].[RESULT]="COMPETENT","Qualified","not qualified")) but it show me this error "You tried to execute a query that does not include the specificied...

Hi Galaxion, Thanks for the reply! The debug.print help me a lot as i can see where is the mistake! My problem have been solve! Thank you very much!

Hi all, Current i have 3 table known as Trainee- nric,name,address Result- nric,course_code,result Courses- course_code,count_core,count_elective,core/elective i link Trainee.nric to Result.nric and Result.course_code to Courses.course_code i need to show the criteria whereby the trainee...

I am new in Microsoft Access and currently facing an error. I have no idea why I get this problem. Same code works well on another system. When i input s898688j (example) in a IC number text box, it will give me run-time error '3061': Too few parameters. Expected 1 When i input 986343dd...