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

comparison statement

Status
Not open for further replies.
detwings9

detwings9

Technical User
Aug 19, 2003
3
0
0
US
I'm having trouble figuring out how to get a field built in a query. I want to compare one field in the query with another and have the result show the lower value. Any help would be greatly appreciated.

I guess there is no IF [Expr1]<=[Expr2], then [Expr1], else [Expr2]

I hope this explains what I'm trying to do.
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
Code Comparison in office - I'd normally use Notepad++ with compare plugin - Not Word Doc compare? 1
Replies
2
Views
48
lameid
lameid
kazaccess
  • Locked
  • Question
Mathematical Comparison Operators in Combo Box and Query
Replies
3
Views
40
kazaccess
kazaccess
dan08
  • Locked
  • Question
Invalid Procedure IIf Statement 2
Replies
2
Views
33
dan08
dan08
shaunacol
  • Locked
  • Question
insert statement not working
Replies
6
Views
25
dhookom
dhookom
cimoli
  • Locked
  • Question
How to get Nested IIF statements to stay number 1
Replies
8
Views
59
cimoli
cimoli

Part and Inventory Search

Sponsor

Back
Top