• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

How to concatinate 2 numeric fileds but leave out the ".00"

In Access, how to concatinate 2 numeric fileds but leave out the ".00"?  I need the field to remain numeric, but I just want the fields left of the decimal.
0
kgittinger
Asked:
kgittinger
  • 3
  • 2
  • 2
  • +1
1 Solution
 
Dale FyeCommented:
Can you give us a couple of examples?

Normally you would use the Int() function to strip the decimals from a value, but you don't normally "concatenate" numeric fields either.
0
 
mbizupCommented:
Try this:

SELECT CInt(Field1) & Cint(Field2) as NewField
From YourTable
0
 
Rey Obrero (Capricorn1)Commented:

try this

 concVal=clng(left([f1],Instr([f1],".")-1) & left([f2],Instr([f2],".")-1))
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
kgittingerAuthor Commented:
Works just fine
0
 
Dale FyeCommented:
Did you really intend to award me all of the points?  (not that I'm complaining)

If not, click the "Request Attention" hyperlink in the bottom right corner of your original post and ask the moderators to reopen the question so that you can award points to another or more than one response.
0
 
mbizupCommented:
fyed,

Take 'em and run.  ;-)

Int() is the simplest, best and first solution here - the author presumably knows where to go from there.
0
 
kgittingerAuthor Commented:
The other two did not work for me
0
 
Dale FyeCommented:
Works for me.

Glad I could help.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now