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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with query condition criteria

Status
Not open for further replies.
AstroTek

AstroTek

Programmer
Apr 27, 2004
21
US
I have three fields on one table to confirm there is a match a fourth field. The fourth field can be(condition) the same as an additional field on another table.

Example bpentid+bproleid +prodbrnid = inv (They are on one table.) If bproleid =MB

then bpentid=billing

How can I make a query with this conditions?

 
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
280
TrekBiker
TrekBiker
caykamanj1966
  • Locked
  • Question
Help With Search Form Results 2
Replies
15
Views
171
caykamanj1966
caykamanj1966
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
205
dhookom
dhookom
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
259
BJZeak
BJZeak
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
191
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top