Need help

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

I want to make a query that does either one criteria OR
another not AND as it is set to as a default. I think it
is possible with SQL but i know nothing about that, could
some one send me some sample code or a link to some sample
code if possible thanks.
 
In the query design view, make sure that your conditions are on separate
lines of the criteria.
 
Originally posted by Jacob
I want to make a query that does either one criteria OR
another not AND as it is set to as a default. I think it
is possible with SQL but i know nothing about that, could
some one send me some sample code or a link to some sample
code if possible thanks.
Click to expand...

Just put the two parameters in two different rows in the criteria of the
query in design mode.

--
J. Paul Schmidt, Freelance Access and ASP Developer
http://www.Bullschmidt.com/Login.asp - Database on the Web Demo
http://www.Bullschmidt.com/Access
Sample Access Invoices Database


Posted via http://dbforums.com
 
Back
Top