Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #10871
| From | "Phil" <phil@stantonfamily.co.uk> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: Roundig problem |
| Date | 2015-06-27 08:58 +0100 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <mmll2j$a3e$1@speranza.aioe.org> (permalink) |
| References | <mmj0jq$f9j$1@speranza.aioe.org> <68428713-4b0a-4a7b-943a-fb36c06a24c3@googlegroups.com> |
On 26/06/2015 14:04:50, Patrick Finucane wrote: > On Friday, June 26, 2015 at 3:56:48 AM UTC-4, Phil wrote: >> I have a field called NoBought for reasons that I can't remember it is >> defined a Double, althogh I only want 4 decimal places. >> >> Code is:- >> BoughtSoldSet!NoBought = Round(TotInt, 4) >> >> TotInt = 214.11 >> >> NoBought comes out as 214.110000610352 >> What's the best way of curing the problem. >> >> Incidently, I can manually or using an update query change the value to the >> required 214.1100 >> >> Thanks >> >> Phil >> >> --- >> This email has been checked for viruses by Avast antivirus software. >> https://www.avast.com/antivirus > > Change it to currency. Set the Format as Standard, decimal 4. > Thanks, Patrick. I wasn't aware that you could use Currency as anything but currency with a currency symbol and only 2 decimal places. Live and learn Phil --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Roundig problem "Phil" <phil@stantonfamily.co.uk> - 2015-06-26 08:56 +0100
Re: Roundig problem Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-06-26 06:04 -0700
Re: Roundig problem "Phil" <phil@stantonfamily.co.uk> - 2015-06-27 08:58 +0100
Re: Roundig problem "Albert D. Kallal" <PleaseNOSpamkallal@msn.com> - 2015-06-27 13:52 -0600
Re: Roundig problem "Phil" <phil@stantonfamily.co.uk> - 2015-06-28 08:53 +0100
csiph-web