Re: Percentages...gone awry.



"jsc3489" <jsc3489@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:101F99FD-1412-49E2-8573-C99F9EEAA7C4@xxxxxxxxxxxxx
> My code reflects a table as such:
>
> Parts Labor Commission
> ------------------------------------------------
> 1%-4% | 1%- 7% | 5%
> 5%-9% | 8%-19% | 10%
> etc.
>
> I've implemented the new code, but I still get 0% as a result in my
> "EQ Commission %" and "Labor Commission %" boxes. Do you think that
> the % in the name is throwing things off?

If the names I guessed at in my sample code are correct, I don't think
so. But are those text boxes also bound to Long Integer or Integer
fields? If so, then they, too, must have their underlying fields
changed to a Field Size that can store fractions.

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

(please reply to the newsgroup)


.



Relevant Pages

  • Re: I need help with a VBA search code
    ... Dirk Goldgar, MS Access MVP ... (please reply to the newsgroup) ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Insert New Record
    ... Dirk Goldgar, MS Access MVP ... (please reply to the newsgroup) ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: OnExitRecord problem
    ... Dirk Goldgar, MS Access MVP ... (please reply to the newsgroup) ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: how do i get rid of the clock for a end time?
    ... Dirk Goldgar, MS Access MVP ... (please reply to the newsgroup) ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Re: users retrieval
    ... Dirk Goldgar, MS Access MVP ... (please reply to the newsgroup) ... Prev by Date: ...
    (microsoft.public.access.formscoding)