Combining 2 fields in a query problems

[Kristian]

Hey,

I have some problems combining 2 fields in a query.

For example: the first field is "1050-04" and the second field is
"02".
However, when i try to combine these two the zero in the second field
disappears. So it reads "1050-042" but i want it to be "1050-0402".
The number 02 increases, so when it reaches 10+ it should be like
"1050-0410".

I can't seem to get it to work.
I hope someone can help me. Thanks in advance.

[Wayne Morgan]

In the Field line of the query design window you would use something like

CombinedField:[Table1].[Field1] & [Table1].[Field2]

What is the data type of the fields, text or number? Is the leading zero
really there on the second field or is it being displayed there by a Format
command? If it is by a Format command you can redo that by

CombinedField:[Table1].[Field1] & Format([Table1].[Field2], "00")

--
Wayne Morgan
Microsoft Access MVP
"Kristian" <kr**************@hotmail.com> wrote in message
news:45*************************@posting.google.co m...

Hey,

I have some problems combining 2 fields in a query.

For example: the first field is "1050-04" and the second field is
"02".
However, when i try to combine these two the zero in the second field
disappears. So it reads "1050-042" but i want it to be "1050-0402".
The number 02 increases, so when it reaches 10+ it should be like
"1050-0410".

I can't seem to get it to work.
I hope someone can help me. Thanks in advance.

[Pieter Linden]

kr**************@hotmail.com (Kristian) wrote in message news:<45*************************@posting.google.c om>...

Hey,

I have some problems combining 2 fields in a query.

For example: the first field is "1050-04" and the second field is
"02".
However, when i try to combine these two the zero in the second field
disappears. So it reads "1050-042" but i want it to be "1050-0402".
The number 02 increases, so when it reaches 10+ it should be like
"1050-0410".

I can't seem to get it to work.
I hope someone can help me. Thanks in advance.

If the second field is of type Number, then you'll have to use the
Format$ function to force it to show leading zeroes.