Re: 2 table Query Error
From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 11/26/04
- Next message: Ken Snell [MVP]: "Re: query from two tables"
- Previous message: Ken Snell [MVP]: "Re: HELP ASAP: The parameter box is preventing me from running queries"
- In reply to: GRCC: "2 table Query Error"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 26 Nov 2004 15:40:07 -0500
Post the SQL statement of the query that is giving you this error. Likely
you need to add the table name in front of the field name in a WHERE clause
or an ORDER BY clause.
--
Ken Snell
<MS ACCESS MVP>
"GRCC" <grccnews@nospamadelphia.net> wrote in message
news:uE3xqX%230EHA.2620@TK2MSFTNGP10.phx.gbl...
> The specified field <number> could refer to more than one table listed in
> the FROM clause of your SQL statement. (Error 3079)
> This is the error message I get. I have a query that works nicely pulling
> info from one table. I need to add a second table from the same DB to pull
2
> more items. It is a Country club member accounting database. When I add
the
> 2nd table and specify the 2 fields I need (the relationships are correct,
> member ID to member ID) I get the afore memtioned error message. The 2
> tables both have a number feild (same data) is this the problem? I have
> tried adding the number field a second time, each one indicating which
table
> to pull from. So why ? I am beginning to think that the program is flawed
> and poorly written because first theused number as a field, but to make it
> worse they used number as a field in 2 different tables. Any Ideas?
> Thanks So Much
> GRCC
>
>
- Next message: Ken Snell [MVP]: "Re: query from two tables"
- Previous message: Ken Snell [MVP]: "Re: HELP ASAP: The parameter box is preventing me from running queries"
- In reply to: GRCC: "2 table Query Error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
