Joining Fields

  • Thread starter Thread starter Kerry
  • Start date Start date
K

Kerry

Hi

I should have asked this question in the queries section
but the newsgroup was unavailable.

I have joined 2 fields together in a query but it has not
carried the formatting with it.

[field 1] = %
[field 2] = £

New Field:[field 1] & " on the first " & [field 2]

the formatting is present in the original fields, its just
not showing it in the new joined field - any ideas on how
to get over this problam would be greatly appreciated.

Thanks very much.

Kerry
 
Hi

I should have asked this question in the queries section
but the newsgroup was unavailable.
Click to expand...

Just from curiosity, how are you connecting to the newsgroups?
Microsoft's website? a newsreader linked to msnews.microsoft.com as
the news server? some other news server?
I have joined 2 fields together in a query but it has not
carried the formatting with it.

[field 1] = %
[field 2] = £
Click to expand...

Correct. Formatting of a field is not stored in the field; a Number
field in particular is just stored as binary bits, and any formatting
is generated on the fly.
New Field:[field 1] & " on the first " & [field 2]
Click to expand...

Use the Format() *function*, which applies a format to the numeric
field and returns a text string: e.g.

New Field: Format([field 1], "#% on the first ") & Format([field 2],
"Currency")
 
FANTASTIC - WORKS A TREAT - THANKS VERY VERY MUCH
-----Original Message-----
Hi

I should have asked this question in the queries section
but the newsgroup was unavailable.
Click to expand...

Just from curiosity, how are you connecting to the newsgroups?
Microsoft's website? a newsreader linked to msnews.microsoft.com as
the news server? some other news server?
I have joined 2 fields together in a query but it has not
carried the formatting with it.

[field 1] = %
[field 2] = £
Click to expand...

Correct. Formatting of a field is not stored in the field; a Number
field in particular is just stored as binary bits, and any formatting
is generated on the fly.
New Field:[field 1] & " on the first " & [field 2]
Click to expand...

Use the Format() *function*, which applies a format to the numeric
field and returns a text string: e.g.

New Field: Format([field 1], "#% on the first ") & Format ([field 2],
"Currency")


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
.
Click to expand...
 
Back
Top