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!

Access Report

Status
Not open for further replies.
Fae

Fae

Instructor
Nov 28, 2002
34
US
Hi there, I am trying the following
This is in an Access Report

In the [Supp Results] field, i am trying to get the [supp result] only if the [Result] is Less than the [Pass Requirement].

how do i do it

Miracles we do immediately ...
imposibilities take a little longer.
 
Sort by date Sort by votes
Never Mind - Worked it out - just for interest, here is the solution
=IIf([Result]<[Pass requirement],[Supp Results],&quot; &quot;)

Miracles we do immediately ...
imposibilities take a little longer.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

pendle666
  • Locked
  • Question
Excel - Quick Access Toolbar - customise with a drop-down menu
Replies
3
Views
187
combo
combo
TrekBiker
  • Locked
  • Question
Using Access Remotely
Replies
2
Views
98
dhookom
dhookom
techie131
  • Locked
  • Question
MS Access Query
Replies
2
Views
85
techie131
techie131
Rick_Stanich
  • Locked
  • Question
Find the nth occurrence of a string and report value to the left. 1
Replies
5
Views
119
Rick_Stanich
Rick_Stanich
pmonett
  • Locked
  • Question
At my wits' end with Access
Replies
8
Views
115
pmonett
pmonett

Part and Inventory Search

Sponsor

Back
Top