Re: Percentages...gone awry.

"jsc3489" <jsc3489@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:21F74DBF-7056-47CB-97FF-8BB95DA39D47@xxxxxxxxxxxxx
> I have a simple form that won't calculate anything I put in as
> expressions (another story) but i also have a few precentage fields.
> I try to put in 0.3 and it goes back to 0.00%. I put in 0.63 and it
> returns 100.00%?!?!?! I'm so donfangled mad I can spit nails.
> W...T...F...? AAARRRGGGHHH!!!!!! Oh, and I HAVE to use #%^@ Access,
> that's what my boss wants. I have it working wonderfully in Excel.

>From the sound of it, you've defined your data fields as one of the
integer types; probably Long Integer, but maybe Integer or even Byte.
Integers have no decimal places, by definition, so if you put in 0.3 it
rounds to 0, and if you put in .63 it rounds to 1 (100%).

Change the Field Size property for those fields to Single or Double,
depending on what sort of precision you need.

Access will treat you very nicely if you just tell her what you want.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

Relevant Pages

  • Re: Firstname Lastname - Lastname, Firstname
    ... query that updates these fields with expressions using Instr(), Mid, ... MS Access MVP ... Change Gary Weiss to Weiss, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Counting based on criteria
    ... In a control use the following expressions to get a count. ... John Spencer ... Access MVP 2002-2005, 2007 ...
    (microsoft.public.access.reports)
  • Re: DateAdd Working Day Query
    ... Access MVP 2002-2005, 2007-2008 ... University of Maryland Baltimore County ... I am fairly new to access, particularly to expressions as complicated as ... use in an query that calculates 15 working days from the 'Date Report ...
    (microsoft.public.access.queries)
  • Re: Adding values froma field to a totals box
    ... We don't know either since you haven't provided any expressions or control ... MS Access MVP ... "Duane Hookom" wrote: ... You can only sum expressions based on field from your record source. ...
    (microsoft.public.access.formscoding)
Loading