Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nairnmp

    Slow report

    Trevil, Thanks for the help. I tried making the main query a "make table" query, but that took about 7 min. So, what I did was run the main query as a select. Then went thru the record set and inserted the rows into a temp table myself. I set this temp table as the record source. The report now...
  2. nairnmp

    Slow report

    Trevil In the main query Regulator, Org Spons, License Type, and IDENTIFICATION_VALUE are the fields where the criteria changes. Everything else in the where stays the same. The main query is: SELECT DISTINCTROW [A Qry LicensesCC].Name, [A Qry LicensesCC].[License No], [A Qry...
  3. nairnmp

    Slow report

    dhookom, No [Page] of [Pages].
  4. nairnmp

    Slow report

    Trevil I do have a lot of tables in the sub query. I'm not sure that I can cut the number based on the way the database was designed (not by me). Thanks for the suggestion.
  5. nairnmp

    Slow report

    Hi, I have query that contains one sub-query. When I run the query by itself it takes about 30 seconds to return. The problem is if I make a basic report (no grouping or sorting) around this query it takes 7 minutes to return. Any suggestions? Thanks, Mike

Part and Inventory Search

Back
Top