Search results

  1. A

    Query for Splitting Table

    I need to send them the data in excel. I don't want to make 100 make table queries, and export each data separately into excel. I wanted to know if there was a quicker way of "breaking" or splitting the table into multiple tables by the specialty field. So I'd have one table for each specialty...
  2. A

    Query for Splitting Table

    I wouldn't have posted if I knew of a quicker way to do it. I'm sorry I asked.
  3. A

    Query for Splitting Table

    I have to run reports based on each specialty, and need to keep them separate. I also need to submit separate tables of each speciality to the customer.
  4. A

    Query for Splitting Table

    Counting the data is part 1 of the task. I also need separate tables for each specialty. I guess there is not way to do this other than the select queries and make table query for each individual specialty.
  5. A

    Query for Splitting Table

    I need the data split into smaller tables so I can do provider counts: e.g. 1 table for PCPs, 1 table for OB Gyn Normally, I'd set up a make table query, and do queries for OB Gyn and PCPs. I was just wondering if there is a quicker way of doing this, as there are over 100 specialities...
  6. A

    Query for Splitting Table

    I have a large provider data table with 10,000 rows approximately. I'd like to split the table by the "specialty" column so I have multiple tables based on the speciality column. Is there a query or SQL so that i Can do this quickly without having to do multiple make table queries?
Back
Top Bottom