Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select statement in views (or) 1

Status
Not open for further replies.
Dec 27, 2002
167
US
I an creating a view in my Asset database.
I want to show just Desktops and Laptops that are in the category field.

I can put a statement that says
Select Category = "Laptop"
and the view will show all the Laptops

I can put a statement that says
Select Category = "Desktop"
and the view will show all the Desktops

How do I change it to select both?

Select Category = "Desktop" or "Laptops
 
Try

Select Category = "Desktop":"Laptops"

or

Select (Category = "Desktop"|Category = "Laptops")



Pascal.

I've got nothing to hide, and I'd very much like to keep that away from prying eyes.
 
Thanks the : worked like a charm.

I don't know why I could not find this is notes help or a quick google search.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top