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

Is there a find statement in coding?

Status
Not open for further replies.
zrazzaq

zrazzaq

MIS
Apr 13, 2005
102
US
Hi:
Basically I need a function that would find a decimal and increase it or decrease the number. For example,
0.753
I would need two numbers 0.75 and .076 so I can do this one query... I have no idea how to do this...
Thanks
Zishan
 
Sort by date Sort by votes
I'm assuming you are getting your decimal value from a table...

Code: 
SELECT Round([YourTable]![YourDecimalField], 2) AS Expr1, Round([YourTable]![YourDecimalField], 2) + 0.01 AS Expr2, Round([YourTable]![YourDecimalField], 2) - 0.01 AS Expr3
FROM YourTable
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Find unique rent amount and date this was first charged
Replies
4
Views
625
dhookom
dhookom
Moss100
  • Locked
  • Question
Find error in currency feild 2
Replies
8
Views
976
Andrzejek
Andrzejek
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
3K
SoftwareRT
SoftwareRT
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel (early binding) 1
Replies
2
Views
821
Knicks
Knicks
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel Password Protect Fail
Replies
5
Views
1K
combo
combo

Part and Inventory Search

Sponsor

Back
Top