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!

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

Help w/ Forrmula

Status
Not open for further replies.
CNeeds

CNeeds

Programmer
Mar 24, 2004
111
US
View Selection:
Select Form = "OrderInventory" & Cost != "" | Form = "Inventory"

I would also elimate docs where "OrderInventory" & Cost != 0

I cannot figure out how to get both to work at same time???

Thanks,
Craig
 
Sort by date Sort by votes
How about using brackets ?
Code: 
SELECT (Form="OrderInventory" & Cost!="") | Form="Inventory"

Pascal.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

KK_
  • Locked
  • Question
Is there any way to get machine ID
Replies
1
Views
5K
pmonett
pmonett
Bri123456
  • Locked
  • Question
Full text search ignore words
Replies
3
Views
5K
pmonett
pmonett
MarcLefe
  • Locked
  • Question
IBM Lotus Notes 9 Attaching a microsoft doc (word/excel) to an email
Replies
1
Views
5K
pmonett
pmonett
Sweetworks
  • Locked
  • Question
Help with Agent to Delete Records
Replies
0
Views
97
Sweetworks
Sweetworks
postmaster420
  • Locked
  • Question
need help to create lotus notes agent
Replies
0
Views
116
postmaster420
postmaster420

Part and Inventory Search

Sponsor

Back
Top