Search results

  1. L

    Can two queries be re-written into a single query?

    Hello, I was just wondering if the following two queries can be re-written into one single query or is this not do-able? They are based off a many-to-many relationship between tblPeople and tblJobs with a link table called tblLinkPeoplesJobs in the middle. I am pretty much an SQL novice, so...
  2. L

    Message to inform a record already exists

    Hello, I have three tables on my database - tblPersons, tblJobs and tblLinkPersonToJobs. It is a many to many relationship via the link table as many persons can be linked to many jobs. I have two list boxes on my form (list0 and list35) where I select at least one person from list0...
  3. L

    Query question - how to display an expression field if certain criteria is met?

    Hello, I need to create a query which shows when users have completed at least two or three particular tasks out of a bigger amount of tasks. I have a table displaying users details and the tasks they have completed to allow them to be given a certificate. There are about 8 tasks in total but...
Top Bottom