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!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IIF Issues

Status
Not open for further replies.

lostris

Technical User
Oct 9, 2002
6
US
Ok - I know nothing about IIF, visual basic, sql.. I'm not a programmer. I'm currently setting up a database for my employeer.. one report that I have set up is an invoice. There is one section of the invoice that is causing issues. I need one column to automatically calculate a price based on the percent of another column. Example, if said column has 4-4.9% then the other column needs to multiply the volume times .12 to get the cost. Is it possible? Need some major help here, invoice needs to be up and running by the 28th, thanks!
 
select IIF (saidcolumn >= 4 and saidcolumn <= 4.9, volume * 1.12, volume) as volumeresult from mytable

Type that in using the SQL section of query designer

Kevin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top