Re: SQL Query Invalid operation

From: Dirk Goldgar (dg_at_NOdataSPAMgnostics.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 16:19:50 -0500

"Jonathan" <anonymous@discussions.microsoft.com> wrote in message
news:ED246EF1-6416-4818-B3C8-A3F7E156B380@microsoft.com
> I checked again to make sure all the column names were correct and
> they were. I also tried
>
> SELECT DISTINCT qry_BAREA_RULE_VIEW.ACONSIST AS TERMINAL,
> qry_BELT_IN_AREA_VIEW.INCLUDES
> FROM qry_BAREA_RULE_VIEW, qry_BELT_IN_AREA_VIEW WHERE
> qry_BAREA_RULE_VIEW.AINCLUDES = qry_BELT_IN_AREA_VIEW.CONSIST
>
> This gives me the same error as well. if there where clause is
> removed though they query is than able to output something.
>
> Both tables are made up of values from an oracle database and are
> both text type

The tables from which these queries are extracting data, are they linked
tables, so you're pulling data directly from the Oracle database, or
were they actually imported from Oracle into your Access database? From
the names, it would appear that this query is actually selecting from
other queries. What is the SQL of those queries? Also, what is the
exact error number and message that you are getting?

You've posted this message in the "modulesdaovba" newsgroup. Is there
actually any code involved here, or are you just working in the query
designer? If you're using code to build the querydef or open a
recordset on it, please post the code. 

-- 
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)

Relevant Pages

  • Re: Cant update table data from form
    ... > tables (the form is built on tables, not queries). ... to more than one newsgroup, ... If the record source of the form is a table (not a multi-table query) ...
    (microsoft.public.access.forms)
  • Re: query takes 10 times longer when running other oracle processes
    ... > queries other developers are experencing very slow response when they ... > run very simply query. ... > is unix related issue or Oracle database design/implementation issue. ... DeeDee, don't press that button! ...
    (comp.unix.solaris)
  • Re: Query Error 3073
    ... this newsgroup is about ADP and SQL-Server and has nothing to do with ... Try also to rebuild this query in a blank new MDB ... Taking a look with the SQL-Server Profiler could also give you some hints on ... I created a macro that runs 6 queries, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Query with left outer join all of a sudden wont work?
    ... It isn't just one query that isn't working. ... This query is based on 2 other queries. ... Are the source queries all based on SQL Server ... Please reply to the newsgroup. ...
    (microsoft.public.access.queries)
  • Re: Filter by sum of counts
    ... Please reply to newsgroup only. ... Your third query should look something like: ... since it's not a displayed field in the other two queries. ...
    (microsoft.public.access.queries)