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

I am relatively new for Microsoft a

Status
Not open for further replies.
tade

tade

Technical User
Apr 8, 2003
2
FI
I am relatively new for Microsoft access and to programming but I have a query that takes the value of two fields and multiply them and put the result in alias filed. What I would like to have is to check the result whether it is greater than 1500 and If it is , split the result into two places: the first 1500 in one and the remaining into another textbox in a report so that I can multiply the two values with two different coefficient and get the sum.
Any help in this matter will be appreciated.
Thanks in advance.
 
Status
Not open for further replies.

Similar threads

pavan_pavan
  • Locked
  • Question
Big Issues in Linux Server
Replies
0
Views
271
pavan_pavan
pavan_pavan
aikman
  • Locked
  • Question
Query Operationmanager Database for all sql server instances
Replies
0
Views
199
aikman
aikman
markdmac
  • Locked
  • News
New FAQ
Replies
0
Views
86
markdmac
markdmac
mvvilleza
  • Locked
  • Question
Getting %Process Time for a Process
Replies
0
Views
191
mvvilleza
mvvilleza
harrysml
  • Locked
  • Question
new to scom
Replies
0
Views
197
harrysml
harrysml

Part and Inventory Search

Sponsor

Back
Top