I have several Access tables which I am querying with the Database
Access Wizard. I set the fields up as fielda=fielda or fieldb=fieldb,
etc and run the thing -- it returns the entire table. If I change it
to and (which wouldn't be appropriate anyway) I get a subset of the
table but not all of the entries which meet the criteria. Anybody
have any idea what is going on? Thanks

Can you post your SQL?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


Bob Johnson <(E-Mail Removed)> wrote:
> I have several Access tables which I am querying with the Database
> Access Wizard. I set the fields up as fielda=fielda or fieldb=fieldb,
> etc and run the thing -- it returns the entire table. If I change it
> to and (which wouldn't be appropriate anyway) I get a subset of the
> table but not all of the entries which meet the criteria. Anybody
> have any idea what is going on? Thanks

In a SQL Statement, records are filtered via a WHERE clause. Example:

SELECT * FROM MyTable WHERE LastName = 'Smith'

The above SQL Statement will fetch only records containing a "LastName"
value of "Smith."

I have no idea what "If I change it to and" means.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Bob Johnson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have several Access tables which I am querying with the Database
> Access Wizard. I set the fields up as fielda=fielda or fieldb=fieldb,
> etc and run the thing -- it returns the entire table. If I change it
> to and (which wouldn't be appropriate anyway) I get a subset of the
> table but not all of the entries which meet the criteria. Anybody
> have any idea what is going on? Thanks