Re: A union B works, A union B union C fails
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Nov 2006 17:24:12 -0700
On Tue, 28 Nov 2006 14:15:43 -0800, Phil Smith <phil@xxxxxxxxxxx>
wrote:
Each individual query is fairly simple. One table has fields for three
possible sales reps, I need to treat them as as one set of fields.
Then it's an incorrectly normalized table... I presume you're trying
to fix that problem.
Each query is identical, except for the three fields that refer to Rep1,
Rep2, and Rep3.
A, B, or C run fine seperately.
A union B
B union C
A Union C
all run fine.
A Union B Union C fails with an ODBC error.
ODBC... what's the actual data storage database? Are these linked
tables in Access? What's the actual error message?
I can fudge it with make table/append queries, but any ideas?
Please post your SQL.
John W. Vinson[MVP]
.
- Follow-Ups:
- Re: A union B works, A union B union C fails
- From: Phil Smith
- Re: A union B works, A union B union C fails
- References:
- A union B works, A union B union C fails
- From: Phil Smith
- A union B works, A union B union C fails
- Prev by Date: RE: Query stopped working after entry 615 in table
- Next by Date: Re: Decimal Precision error. GRRRR
- Previous by thread: A union B works, A union B union C fails
- Next by thread: Re: A union B works, A union B union C fails
- Index(es):
Relevant Pages
|
