Database Access Wizard Returns entire dataset

[Bob Johnson]

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

 

[Kathleen Anderson [MVP - FP]]

Can you post your SQL?

 

[Kevin Spencer]

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.