Re: Concatenating fields

Reggie,

Format(Field1, "000-") & Format(Field1, "00-") & Format(Field1, "000")

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
---------------------------

"Reggiee" <Reggiee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:920B6995-E5AD-4A82-9F0B-9BC403C1788D@xxxxxxxxxxxxxxxx
Hi,

I need to concatenate 3 fields where all the fields are number format.

The problem is this - when concatenating them I lose any leading 0's that
may exist in the original tables even thought ive formatted them as for
example 000 to make access put in the leading 0's.

How can I write some SQL which makes the answer more like 001-01-100
rather
than 1-1-100.

Hope this makes sense

Thanks

Reggiee


.

Relevant Pages

  • Re: To Syntax Guru (between... and...)
    ... >> Graham R Seach ... >> Microsoft Access MVP ... > Just as a matter of interest, what is the normal date format in Oz? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Calculate the age
    ... Graham R Seach ... Microsoft Access MVP ... > I am trying to calculate the age of a product in ... > Years/Month format, and was wondering how i could go about ...
    (microsoft.public.access.queries)
  • Re: Calculate age
    ... "Graham R Seach" wrote: ... use UK date format, I often need to format the date in the correct format ... Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Format a number
    ... Graham R Seach ... Microsoft Access MVP ... > I am using the following to format a number in a message ...
    (microsoft.public.access.formscoding)
  • Re: In a report -Using a calculated field in Select Case causes Er
    ... If your format is 2002/2003 and you are doing your development in 2007, ... Dave Hargis, Microsoft Access MVP ... should open on its own and suspend execution of the report. ... The line has not executed, but it will be the next to execute. ...
    (microsoft.public.access.modulesdaovba)