UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> formating data in a query    
 
   
jimmyp
post Jul 22 2008, 03:30 PM
Post #1

New Member
Posts: 1
I need to combine two fields with a query and format the number of decimal places in the new field. I have one field which is a "1" and I need to format as "001" and another which is a counter field and needs to be formatted like "00001". Then I need to join both fields in to one where it is shown as "001-00001". I am new to this and need all the help I can get and thank you in advance for taking the time.

JimmyP
Go to the top of the page
 
+
freakazeud
post Jul 22 2008, 03:32 PM
Post #2

UtterAccess VIP
Posts: 31,413
From: NC, USA
Hi,
I'm not exactly sure why you need to do that but you can probably use the format function for this e.g.:

YourNewCombinedField: Format([FirstOtherField],"000") & "-" & Format([SecOtherField],"00000")

HTH
Good luck
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 26th May 2013 - 01:07 AM