Joining Fields

[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

 

[John Vinson]

Hi

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

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] = £

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]

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")