how get lower of 2 fields

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

i have 2 fields in my form one is sales price the other
is appraised value i want the 3rd field to be the
lesser of the two how can i do this

appraised value $100,000
sales price $90,000
lower $90,000
 
Create a query into this table.

In query design view, type this into a fresh column of the Field row:
LowerPrice: IIf([Field1] < [Field2], [Field1], [Field2])
substituting the names of your fields for Field1 and Field2.

You should not store this in a table.
 
why should i not store this in a table it appears in the
form but does not appear in the table is this why your
saying that?
-----Original Message-----
Create a query into this table.

In query design view, type this into a fresh column of the Field row:
LowerPrice: IIf([Field1] < [Field2], [Field1], [Field2])
substituting the names of your fields for Field1 and Field2.

You should not store this in a table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

i have 2 fields in my form one is sales price the other
is appraised value i want the 3rd field to be the
lesser of the two how can i do this

appraised value $100,000
sales price $90,000
lower $90,000
Click to expand...


.
Click to expand...
 
You shouldn't store it in a table because it's generally recommended
practice to *not* store calculated values in tables, unless there's
specific reason it needs to be done. Anything calculated can be
recalculated.

It's also generally recommended to not post the same thing 6 times, even
if you are using different names. People don't like it.

grep

why should i not store this in a table it appears in the
form but does not appear in the table is this why your
saying that?
-----Original Message-----
Create a query into this table.

In query design view, type this into a fresh column of
Click to expand...

the Field row:
LowerPrice: IIf([Field1] < [Field2], [Field1],
[Field2])

substituting the names of your fields for Field1 and
Field2.

You should not store this in a table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
i have 2 fields in my form one is sales price the other
is appraised value i want the 3rd field to be the
lesser of the two how can i do this

appraised value $100,000
sales price $90,000
lower $90,000
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top