John
Sun Jul 18 18:07:40 CDT 2004
For future reference....
It was corrected when I changed:
WHERE (((Manufacturers.Manuf)="Hitachi"));
to:
WHERE (Manufacturers.Manuf='Hitachi');
John P.
"John Parker" <newsgroup@rightfast.com> wrote in message
news:e4eMKDPbEHA.904@TK2MSFTNGP09.phx.gbl...
> Thanks Ian, you have been very helpful, however when I add a comma I get
an
> error..
>
> I did however figure how to get more from the error message and now get:
>
> ===================
>
> Database Results Wizard Error
> Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
> Expected 1.
> Number: -2147217904 (0x80040E10)
> Source: Microsoft OLE DB Provider for ODBC Drivers
>
> ===================
>
>
>
> "Ian" <zzz@hotmail.com> wrote in message
> news:OV6r%232IbEHA.3664@TK2MSFTNGP12.phx.gbl...
> > I had to add a comma at the end of my select statement, without this I
was
> > getting simular errors! Also check where you place the WHERE statement
> and
> > the format WHERE ((Manufacturers.Manuf)="Hitachi");
> >
> > Failing that check out the following site it was recommended by another
> > poster and has lots of very useful info.
> >
> >
http://www.spiderwebwoman.com/resources/
> >
> > Hope this helps.
> >
> > Ian
> >
> > "John Parker" <newsgroup@rightfast.com> wrote in message
> > news:%236Ia7QFbEHA.556@tk2msftngp13.phx.gbl...
> > > I have joined 3 tables to show combined information and using the
custom
> > SQL
> > > feature in Wizard, everything works okay until I try to filter a
certain
> > > field (in this example Manuf)
> > >
> > > I have tested the SQL in the origial database using a query (which is
> > where
> > > I got the code) and it works fine, but as soon as I use it online I
get
> > the
> > > following error:
> > > =============
> > >
> > > Database Results Wizard Error
> > > The operation failed. If this continues, please contact your server
> > > administrator.
> > >
> > > =============
> > >
> > > Everything works okay until I add the WHERE info:
> > >
> > >
> > > SELECT Manufacturers.Manuf, Models.Model, Lamps.Lamp_Desc,
> > > Lamps.Lamp_MSRP_Cdn, Lamps.Lamp_SP_Cdn
> > > FROM Manufacturers INNER JOIN (Lamps INNER JOIN Models ON
Lamps.Lamp_ID
> =
> > > Models.Lamp_Desc) ON (Manufacturers.Manuf_ID = Lamps.Manuf) AND
> > > (Manufacturers.Manuf_ID = Models.Manuf)
> > > WHERE (((Manufacturers.Manuf)="Hitachi"));
> > >
> > >
> > > Hope this makes sense..
> > >
> > > John Parker
> > >
> > >
> >
> >
>
>