How do I report a bug in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The following query (I'm simplifying it a bit) causes an error in design view
that causes the query to be truncated:

Select table1.item1, table2.*, table3.item2 from
(table1 INNER JOIN table2 ON table1.name = table2.name) INNER JOIN table3 ON
table3.name = table1.anothername

The error is "Microsoft Access Can't Represent the Join Expression
table3.name = table1.anothername in Design View"

This error occurs in Access 2003, 2000, and 97. The knowledge base for this
error shows cases where the Simple Query Wizard inserts too many parentheses.
This is not the case here. If anyone has a workaround, great, otherwise,
I'd like to report the bug, but I can't figure out how!
Thanks,
(e-mail address removed)
 
hi,
I don't think this is a bug.
there are several queries that access can not display in
design mode. union queries, pass through queries and data
definitin queries.
sometimes if you don't get your join right, the query wont
run and you will get a message about ambigious joins.
try joining table3.name to table1.name or use a double join
joining table3.name to table1.name and table3.name to
table1.anothername.
but what ever. access don't like the way you have it set
up.
 
Back
Top