query and percent, weird 1

[Zorro1265]

I have a query which takes a couple of fields and puts them together with some text strings.

[CatPhrase] & " exercise capacity in a test terminated due to " & [StopReason] & " at " & [peakMets] & " METS of work and " & [%MPHR] & " maximal heart rate."

The feild [%MPHR] is a percentage. I have the property set to percentage but when I run the query the result is

"Mildly reduced exercise capacity in a test terminated due to Claudication, Chest pain at 8.3 METS of work and 1 maximal heart rate."

The 1 should be 100%, which is what is shows in the feild by itself. How can I keep the percent formatting in my string of text.

 

[tlbroadbent]

Try this...

... " METS of work and " & Format$([%MPHR],"0%&quot & " maximal heart rate."

Terry

http://members.home.net/tlbroadbent/index.htm

 

[Zorro1265]

That was the ticket, I would have never ever guessed on that one! Zorro