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

Specification formatting numbers as X.00, want only X if number has no

Status
Not open for further replies.

stessie

Programmer
Nov 22, 2000
26
IE
Hi,
Am using a specification created from an access table
One database outputs numbers with two decimal places e.g. 100.00, another specification created from an identical access table (I exported the table)but in a different access database ouputs numbers with no decimals unless they are required e.g. 100
How can I stop the numbers being outputted with two decimal places? Am using Access 95 and don't want to use schema.ini if I can get away without it

Thanks in advance
Stessie

;-)
 
Hi,
Am sorted imported the spec from the database it was working in, added in my new fields and now it is fine

Thanks

;-)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top