Hi

Access 2007

I have 2 fixed numerical fields that I used in an
expresssion to add together:

=txtPostage1_IncVAT + txtBuyerItemCost_IncVAT
9.40 + 209.99 = 219.39

What I would like is to be able alter the whole
part of the field i.e. the 219, to 218.99 and discard
the .39 part

Best regards
Bob

On Tue, 19 Oct 2010 09:22:46 -0700 (PDT), bobdydd
<reallyuseful2004 (AT) yahoo (DOT) co.uk> wrote:

So you want to take a correct and legal mathematical expression and return an
incorrect and probably illegal result?????

What's the rationale? And what business rule do you want to apply - 0.01 less
than the next lower whole number, or what?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

bobdydd wrote:
I'm as baffled as John, but here's my guess anyways. It might give you the
clue enable you to get what you really want:

=Int(txtPostage1_IncVAT + txtBuyerItemCost_IncVAT) - .01

Thanks for the answer. It works Ok

It is being used to enter prices including postage on eBay
and finish the price with a .99

It's a sales thing

Thanks guys

On Tue, 19 Oct 2010 11:18:24 -0700 (PDT), bobdydd
<reallyuseful2004 (AT) yahoo (DOT) co.uk> wrote:


Oh gawd... Where'd I put the prozac and the antacid?

--
croy