Search results

Thanks for the options indeed. I have considered second option while I was building the function at the time. However, it didn't work while I put variable into query. It just weird works perfect in VB but doesn't work as an independent query. I believe you built a sample for me at that time...

I need to create a report based on the result below so I can print in the way I want. I need to find a way to inner join the result with main employee information to generate a list of people and their qualification. I know how to do in query, but how do I call the result from this VB code...

I'm working on a database which records the shifts of staffs in a date format. However I need to project those date data into a calendar like chart which indicates their availability. And each staff will act like a single line item. I know the gantt chart is quite similiar, but not exact. And...

Thanks so much, It works!!:D

Hi jz, I did a bit modify on the code and it worked perfectly in both nestTestquery and form view with predefined qual ID. However, when I insert the variable SelectIDs in to the VB code, something werid happened. It promot a message with Qualification ID I selected from the list box and asking...

You right. I do have a bit knowledge in other language, but just haven't been much involved in sql and vb. So it is easier for me to understand those function in coding rather than getting familiar with the windows type interface. Didn't think much about most of selected qualifications case...

silly me, I was confused with that syntax before. Since my original thought was to run individual query to list the person with user defined qualification, then with one extra query which compares all those result that contains the same ID and group by to generate single name. Thus I thought...

Would you mind explain this code from ur attachment to me, I found hard to understand the syntax. Many thanks "mySQL = mySQL & " WHERE (((tblStaffQualifications.Qual_ID) In (" & strIDs & ")))) as Q1 INNER JOIN tblStaff ON Q1.Staff_ID = tblStaff.Staff_ID""

Ok I got it, it's a nest query. smart way. Thank you!!:)

Hi Jzwp, Yes you aree right. For every new qualification, it need to add one more column in that validation table which is very nasty. And I did find a way to search criteria just like you did. Create a query for every user defined criteria and one extra query which group by all the result by...

Hi, I'm quite new to access and I'm building a query for HR people to find the right qualified person from range of data. Since there are 40-60 Qualifications depending on the employees's profile. The original employee database contains two tables. one is the general information with Staff ID as...