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

code for minimum value

Status
Not open for further replies.
shelspa

shelspa

Technical User
Dec 13, 2001
66
US
I have three fields of data. I want a fourth field to show the minimum of the three. I put the following code in the after update event of the third field:

Me!Minimum_Field.Value = Minimum(Me!Field1.Value, Me!Field2.Value, Me!Field3.Value)

error = minimum not defined.

This applies to only one record. There are no nulls or zeros only positive integers to deal with. Ideas?
 
Status
Not open for further replies.

Similar threads

I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
810
hermanlaksko
hermanlaksko
TechieJr
  • Locked
  • Question
Filtering for null or empty field
Replies
8
Views
1K
dhookom
dhookom
BallunarCrew
  • Locked
  • Question
Looking for a color chart 1
Replies
2
Views
333
BallunarCrew
BallunarCrew
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
676
dhookom
dhookom
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke

Part and Inventory Search

Sponsor

Back
Top