Cannot Combine Numeric and Text Problem

[Guest]

In my Table

Field 1 Field 2
120.100 M
120.100 S
127.000 M
128.975 M

In my query

Field 1 Field 2 Result:Field 1 & " " & Field 2

120.100 M 120.1 M
120.100 S 120.1 S
127.000 M 127 M
128.975 M 128.975 M

But I want all digit like this 120.100 M, 120.100 S, 127.000 M and 128.975 M
How can I do?

 

[John W. Vinson]

In my Table

Field 1 Field 2
120.100 M
120.100 S
127.000 M
128.975 M

In my query

Field 1 Field 2 Result:Field 1 & " " & Field 2

120.100 M 120.1 M
120.100 S 120.1 S
127.000 M 127 M
128.975 M 128.975 M

But I want all digit like this 120.100 M, 120.100 S, 127.000 M and 128.975 M
How can I do?

Result: Format([Field 1], "#.000") & " " & [Field 2]

John W. Vinson [MVP]

 

[Guest]

Thanks John