Expression in numerical fields

  • Thread starter Thread starter bobdydd
  • Start date Start date
B

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
 
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
Click to expand...

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
 
bobdydd said:
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
Click to expand...

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
 
Back
Top