Report won't display percentages

[Tara]

I have a report based on a query. The query is set up to format results as a
percentage. They show up correctly in the query. They show up correctly in
the report too, but I wanted to add them into a text box so the result ends
up being part of a sentence. When I do that, the numbers show up in decimal
form. I've tried everything I can think of to get it to show up as a
percentage. I even went back to the query and tried to tie the text in there
instead of in the report, but the same thing happens. Here's an example of
the text box expression in the report:

="Client actively/appropriately participated during visits" & " " &
([PartScore]) & " of the time"

Can this be done? Thanks for any help...

 

[Duane Hookom]

Try use the Format function
="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent") & " of the time"

 

[Tara]

Thanks for the suggestion, but when I try it I get an error message that says
it contains Invalid Syntax. Any additional thoughts?

Try use the Format function
="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent") & " of the time"

--
Duane Hookom
Microsoft Access MVP

I have a report based on a query. The query is set up to format results as a
percentage. They show up correctly in the query. They show up correctly in
the report too, but I wanted to add them into a text box so the result ends
up being part of a sentence. When I do that, the numbers show up in decimal
form. I've tried everything I can think of to get it to show up as a
percentage. I even went back to the query and tried to tie the text in there
instead of in the report, but the same thing happens. Here's an example of
the text box expression in the report:

="Client actively/appropriately participated during visits" & " " &
([PartScore]) & " of the time"

Can this be done? Thanks for any help...

 

[Al Campagna]

Tara,
Copy and Paste "exactly" what you entered in your = statement.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Thanks for the suggestion, but when I try it I get an error message that
says
it contains Invalid Syntax. Any additional thoughts?

Try use the Format function
="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent") & " of the time"

--
Duane Hookom
Microsoft Access MVP

I have a report based on a query. The query is set up to format
results as a
percentage. They show up correctly in the query. They show up
correctly in
the report too, but I wanted to add them into a text box so the result
ends
up being part of a sentence. When I do that, the numbers show up in
decimal
form. I've tried everything I can think of to get it to show up as a
percentage. I even went back to the query and tried to tie the text in
there
instead of in the report, but the same thing happens. Here's an
example of
the text box expression in the report:

="Client actively/appropriately participated during visits" & " " &
([PartScore]) & " of the time"

Can this be done? Thanks for any help...

 

[Tara]

Okay...Thanks. Here it is:

="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent")& " of the time"

Tara,
Copy and Paste "exactly" what you entered in your = statement.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Thanks for the suggestion, but when I try it I get an error message that
says
it contains Invalid Syntax. Any additional thoughts?

Try use the Format function
="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent") & " of the time"

--
Duane Hookom
Microsoft Access MVP


:

I have a report based on a query. The query is set up to format
results as a
percentage. They show up correctly in the query. They show up
correctly in
the report too, but I wanted to add them into a text box so the result
ends
up being part of a sentence. When I do that, the numbers show up in
decimal
form. I've tried everything I can think of to get it to show up as a
percentage. I even went back to the query and tried to tie the text in
there
instead of in the report, but the same thing happens. Here's an
example of
the text box expression in the report:

="Client actively/appropriately participated during visits" & " " &
([PartScore]) & " of the time"

Can this be done? Thanks for any help...

 

[Duane Hookom]

Is this all on one line? If you copied and pasted, what happened to the space
between ) and &?

Make sure the name of the text box is not also the name of a field. This
also assumes PartScore is numeric (it appears right-aligned in datasheet
view).

--
Duane Hookom
Microsoft Access MVP

Okay...Thanks. Here it is:

="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent")& " of the time"

Tara,
Copy and Paste "exactly" what you entered in your = statement.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Thanks for the suggestion, but when I try it I get an error message that
says
it contains Invalid Syntax. Any additional thoughts?

:

Try use the Format function
="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent") & " of the time"

--
Duane Hookom
Microsoft Access MVP


:

I have a report based on a query. The query is set up to format
results as a
percentage. They show up correctly in the query. They show up
correctly in
the report too, but I wanted to add them into a text box so the result
ends
up being part of a sentence. When I do that, the numbers show up in
decimal
form. I've tried everything I can think of to get it to show up as a
percentage. I even went back to the query and tried to tie the text in
there
instead of in the report, but the same thing happens. Here's an
example of
the text box expression in the report:

="Client actively/appropriately participated during visits" & " " &
([PartScore]) & " of the time"

Can this be done? Thanks for any help...

 

[Tara]

That for getting back to me Duane. You're right, there was a space missing.
I added it, but I'm still getting the error message.

The text box has a different name, so that can't be the issue.

Yes, PartScore is numeric.

Any additional help would be greatly appreciated!

Is this all on one line? If you copied and pasted, what happened to the space
between ) and &?

Make sure the name of the text box is not also the name of a field. This
also assumes PartScore is numeric (it appears right-aligned in datasheet
view).

--
Duane Hookom
Microsoft Access MVP

Okay...Thanks. Here it is:

="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent")& " of the time"

Tara,
Copy and Paste "exactly" what you entered in your = statement.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


Thanks for the suggestion, but when I try it I get an error message that
says
it contains Invalid Syntax. Any additional thoughts?

:

Try use the Format function
="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent") & " of the time"

--
Duane Hookom
Microsoft Access MVP


:

I have a report based on a query. The query is set up to format
results as a
percentage. They show up correctly in the query. They show up
correctly in
the report too, but I wanted to add them into a text box so the result
ends
up being part of a sentence. When I do that, the numbers show up in
decimal
form. I've tried everything I can think of to get it to show up as a
percentage. I even went back to the query and tried to tie the text in
there
instead of in the report, but the same thing happens. Here's an
example of
the text box expression in the report:

="Client actively/appropriately participated during visits" & " " &
([PartScore]) & " of the time"

Can this be done? Thanks for any help...

 

[Duane Hookom]

You should troubleshoot by trying a number of different options/syntax to
find out what works and what doesn't. Report back to us what different
expressions you tried and your results.

--
Duane Hookom
Microsoft Access MVP

That for getting back to me Duane. You're right, there was a space missing.
I added it, but I'm still getting the error message.

The text box has a different name, so that can't be the issue.

Yes, PartScore is numeric.

Any additional help would be greatly appreciated!

Is this all on one line? If you copied and pasted, what happened to the space
between ) and &?

Make sure the name of the text box is not also the name of a field. This
also assumes PartScore is numeric (it appears right-aligned in datasheet
view).

--
Duane Hookom
Microsoft Access MVP

Okay...Thanks. Here it is:

="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent")& " of the time"

:

Tara,
Copy and Paste "exactly" what you entered in your = statement.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


Thanks for the suggestion, but when I try it I get an error message that
says
it contains Invalid Syntax. Any additional thoughts?

:

Try use the Format function
="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent") & " of the time"

--
Duane Hookom
Microsoft Access MVP


:

I have a report based on a query. The query is set up to format
results as a
percentage. They show up correctly in the query. They show up
correctly in
the report too, but I wanted to add them into a text box so the result
ends
up being part of a sentence. When I do that, the numbers show up in
decimal
form. I've tried everything I can think of to get it to show up as a
percentage. I even went back to the query and tried to tie the text in
there
instead of in the report, but the same thing happens. Here's an
example of
the text box expression in the report:

="Client actively/appropriately participated during visits" & " " &
([PartScore]) & " of the time"

Can this be done? Thanks for any help...

 

[Tara]

Thanks Duane. I'll do that. Unfortunately, I have to leave right now. I'll
post back tomorrow though.

You should troubleshoot by trying a number of different options/syntax to
find out what works and what doesn't. Report back to us what different
expressions you tried and your results.

--
Duane Hookom
Microsoft Access MVP

That for getting back to me Duane. You're right, there was a space missing.
I added it, but I'm still getting the error message.

The text box has a different name, so that can't be the issue.

Yes, PartScore is numeric.

Any additional help would be greatly appreciated!

Is this all on one line? If you copied and pasted, what happened to the space
between ) and &?

Make sure the name of the text box is not also the name of a field. This
also assumes PartScore is numeric (it appears right-aligned in datasheet
view).

--
Duane Hookom
Microsoft Access MVP


:

Okay...Thanks. Here it is:

="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent")& " of the time"

:

Tara,
Copy and Paste "exactly" what you entered in your = statement.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


Thanks for the suggestion, but when I try it I get an error message that
says
it contains Invalid Syntax. Any additional thoughts?

:

Try use the Format function
="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent") & " of the time"

--
Duane Hookom
Microsoft Access MVP


:

I have a report based on a query. The query is set up to format
results as a
percentage. They show up correctly in the query. They show up
correctly in
the report too, but I wanted to add them into a text box so the result
ends
up being part of a sentence. When I do that, the numbers show up in
decimal
form. I've tried everything I can think of to get it to show up as a
percentage. I even went back to the query and tried to tie the text in
there
instead of in the report, but the same thing happens. Here's an
example of
the text box expression in the report:

="Client actively/appropriately participated during visits" & " " &
([PartScore]) & " of the time"

Can this be done? Thanks for any help...

 

[Tara]

Not sure how or why exactly, but I finally got it to format correctly.
Here's the structure I came up with that seems to work:

="Client actively/appropriately participated during visits" & " " &
Format([PartScore],"Percent") & " " & "of the time"

It's almost identical to the other one with the exception of additional
spaces, and none of the changes I made seem like they should have made a
difference at all. I'm not going to question it though...

Thanks everyone for your help.

Thanks Duane. I'll do that. Unfortunately, I have to leave right now. I'll
post back tomorrow though.

You should troubleshoot by trying a number of different options/syntax to
find out what works and what doesn't. Report back to us what different
expressions you tried and your results.

--
Duane Hookom
Microsoft Access MVP

That for getting back to me Duane. You're right, there was a space missing.
I added it, but I'm still getting the error message.

The text box has a different name, so that can't be the issue.

Yes, PartScore is numeric.

Any additional help would be greatly appreciated!

:

Is this all on one line? If you copied and pasted, what happened to the space
between ) and &?

Make sure the name of the text box is not also the name of a field. This
also assumes PartScore is numeric (it appears right-aligned in datasheet
view).

--
Duane Hookom
Microsoft Access MVP


:

Okay...Thanks. Here it is:

="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent")& " of the time"

:

Tara,
Copy and Paste "exactly" what you entered in your = statement.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


Thanks for the suggestion, but when I try it I get an error message that
says
it contains Invalid Syntax. Any additional thoughts?

:

Try use the Format function
="Client actively/appropriately participated during visits " &
Format([PartScore],"Percent") & " of the time"

--
Duane Hookom
Microsoft Access MVP


:

I have a report based on a query. The query is set up to format
results as a
percentage. They show up correctly in the query. They show up
correctly in
the report too, but I wanted to add them into a text box so the result
ends
up being part of a sentence. When I do that, the numbers show up in
decimal
form. I've tried everything I can think of to get it to show up as a
percentage. I even went back to the query and tried to tie the text in
there
instead of in the report, but the same thing happens. Here's an
example of
the text box expression in the report:

="Client actively/appropriately participated during visits" & " " &
([PartScore]) & " of the time"

Can this be done? Thanks for any help...