Expression in numerical fields

[bobdydd]

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

 

[John W. Vinson]

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

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/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Bob Barrows]

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

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

 

[bobdydd]

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