Search results

  1. M

    Help with a query with an IN statement

    Thanks Minty. I ended up setting it up like you said and how I set up other subforms on the form. I had an "image" of how I wanted it to look on the form and doing it that way wasn't what I had in mind. However, doing that way got it to work and allowed me to add some other things into the...
  2. M

    Help with a query with an IN statement

    Thanks for getting back to me, don't worry about the time delay, things happen and this isn't your job (I think). I do understand normalization and I would normally set that up like you suggested. What I don't know how to do is use a normalized table like you suggest to then transfer it to a...
  3. M

    Help with a query with an IN statement

    Here is tblNeeds. I do have a customer table, but it has all the info on it (Name, address, phone, etc) tblNeeds is just the CustId and the needs and if they have been met. There is also a WorkCompleted table. The work completed has it's own PK (workNum) with the work details attached to it...
  4. M

    Help with a query with an IN statement

    I have a problem that I have been trying to solve and have looked all over for a solution with no success. I know the solution is probably simple and I am probably over thinking this. Here is the situation: tblNeeds: I have a series of fields with different items that a customer might need...
Top Bottom