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

Produce whole numbers from queries that calculate values

Status
Not open for further replies.

Radman

Programmer
Jan 20, 2000
22
AU
I have create a query in the qbe and i have used it in a graph. I want to show the result values of each columnin in the table but i don't want any decimal values to be show in the values only whole numbers.<br><br>How can i limit this so that olyu whole numbers appear.
 
x=int(mywhole number)<br>Integer function strips off decimals
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top