Re: Need SQL optimization help

If you post a description of what you are attempting to do, as simply
as possible, it might be easier to come up with a better solution.

ie in very basic terms, what sort of data each of the three tables
contains (create table and create index statements for the tables are
useful), the relationships between them and what you are attempting to
achive with the query etc ... then it is much easier for someone to
test out alternatives and suggest solutions.

If you post that info, I will do my best to have a look - but I can't
promise anything!

.

Relevant Pages

  • Disabling the personal Workbook?
    ... query the database for information, then sort the data, and email it to ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Sort table, not with SQL!
    ... I found a solution to sorting a table! ... Create a query that will sort the table as needed. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: from table to form
    ... if you're talking about *sorting* records, don't do it at the table level. ... sort the records directly in the form, or sort them in a query and bind the ... query to the form. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: sortin a report by NULL valuse
    ... > the source of the report. ... Some of the records in the query have a NULL date ... whereas some other databases would sort them to the bottom. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Make Table Query - Sorting Errors
    ... Dim OutputTable As DAO.Recordset ... The query to concatenate the CAMPNO values will need to be LOOKING at the ... If you post the query you are using to do this, I beleive we can get it to ... Is there a command that I can use in the module code to first sort the ...
    (microsoft.public.access.queries)