using if and then in expressions

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

How do I put together an expression that if a certain
product cat. starts with these 2 numbers then use ad a
diferent percentage to the unit price.

There are products which are catergorized by the first or
second number in catogory field of my table.

I would like to have my form display a different
calulation in a box if if the first 2 #'s start with this
or mabye even that.

How do I use if and then in a calculated expression.

I greatly appreciate some insight
Thank you!
 
Gary

If you are basing your form on a query, then you can use the IIF() function
to create "display" values in your query (and in your form).

(?how is this a tablesdbdesign question?)

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top