Re: Item cannot be found in the collection corresponding to the requested name or ordinal

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"Ralph" <nt_consulting64@xxxxxxxxx> wrote in message
news:zOudna7htIL0K8DeRVn-oA@xxxxxxxxxxxxxxx
>
> <gunnarnime@xxxxxxxxx> wrote in message
> news:1130211740.763136.235810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Sorry, I should have mentioned that I'm trying to accompliash this task
> > in Access. Unfortunately, I still cannot figure out the error.
> >
>
> What happens when you copy the sql into a Query in MSAccess?
> What error does it report?
>
> -ralph
>

Paste the completed SQL here so we can take a look. One never knows - it is
tough to duplicate your code without the same tables, data, etc.

You are doing some interesting joins - perhaps if you also posted your query
in a MSAccess or SQL newsgroup. The error does sound a bit like it is
complaining about a join sub-collection.

hth
-ralph


.

Relevant Pages

  • TADOQuery and TDateTime Field Query
    ... I have a puzzling problem with a query using a TADOQuery component. ... when I execute the following SQL against the same MSAccess 2002 database I get an error: ...
    (borland.public.delphi.database.ado)
  • SQL queries that have parameters passed by user
    ... the criteria dynamically either through the web or from MSAccess or ... The query also does a GROUP BY the state and other variables that are ... I know how to get MSAccess and asp pages to do the sorting and ... selecting against an SQL tbl or view, but when access queries the same ...
    (comp.databases.ms-sqlserver)
  • Re: SQL queries that have parameters passed by user
    ... all my sql work was done through the Enterprise ... several fields and filters on a criteria that I would like to be user ... The query works fine in MS SQL and seems to be fairly quick, ... >> the criteria dynamically either through the web or from MSAccess or ...
    (comp.databases.ms-sqlserver)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)