Reporting buttons

[Krissy]

I have to create a report on a form i made. Using a wizard i want to organise
my data so if people have clicked on a button in the form then it shows up
first. Now i no how to organise my data by if they have clicked on the button
or not, however, if the have clicked on the button it arranges the
information under a heading of -1, any ideas if i can get it to say inactive
or something instead of -1. if you dont understand wat im saying ask n il try
to retype it. Also is there a recomended button or tick box i should use on
the report so that the number wont show up like -1.

 

[Allen Browne]

You have a yes/no field named Inactive, and you want to show the word
"Inactive" instead of the -1 that Access uses when the field is true?

If so, you could place a text box on your report, and set this as its
Control Source:
=IIf([Inactive], "Inactive", "Active")

 

[Krissy]

I have a toggle button on a report for when the information on the form is
inactive (eg. the client has left so their case is now inactive, ie. click t
button) and now i need to create a report of all the clients that are active
and inactive, but when i organise by active and inactive only numbers come up
as the title under active or inactive and then the info follows. they layout
is right just wanna get rid the number. Also, not that skilled in writing
instruction thingys, where bouts do i write =IIf([Inactive], "Inactive",
"Active")

You have a yes/no field named Inactive, and you want to show the word
"Inactive" instead of the -1 that Access uses when the field is true?

If so, you could place a text box on your report, and set this as its
Control Source:
=IIf([Inactive], "Inactive", "Active")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have to create a report on a form i made. Using a wizard i want to
organise
my data so if people have clicked on a button in the form then it shows up
first. Now i no how to organise my data by if they have clicked on the
button
or not, however, if the have clicked on the button it arranges the
information under a heading of -1, any ideas if i can get it to say
inactive
or something instead of -1. if you dont understand wat im saying ask n il
try
to retype it. Also is there a recomended button or tick box i should use
on
the report so that the number wont show up like -1.

 

[Allen Browne]

Open your report in design view.

Add a text box to the report where you want the words.
(Get the text box from the Tool box, opened through View menu.)

Type the expression into the Control Source property of the text box.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a toggle button on a report for when the information on the form is
inactive (eg. the client has left so their case is now inactive, ie. click
t
button) and now i need to create a report of all the clients that are
active
and inactive, but when i organise by active and inactive only numbers come
up
as the title under active or inactive and then the info follows. they
layout
is right just wanna get rid the number. Also, not that skilled in writing
instruction thingys, where bouts do i write =IIf([Inactive], "Inactive",
"Active")

You have a yes/no field named Inactive, and you want to show the word
"Inactive" instead of the -1 that Access uses when the field is true?

If so, you could place a text box on your report, and set this as its
Control Source:
=IIf([Inactive], "Inactive", "Active")

I have to create a report on a form i made. Using a wizard i want to
organise
my data so if people have clicked on a button in the form then it shows
up
first. Now i no how to organise my data by if they have clicked on the
button
or not, however, if the have clicked on the button it arranges the
information under a heading of -1, any ideas if i can get it to say
inactive
or something instead of -1. if you dont understand wat im saying ask n
il
try
to retype it. Also is there a recomended button or tick box i should
use
on
the report so that the number wont show up like -1.

 

[Krissy]

k thanks, helpful, just 2 more things, it labels it all as inactive, even the
unticked boxes (ie the active ones) also wat is the parameter value, it asks
me for that when i go back into report view and dosnt change anything no
matter what i type

Open your report in design view.

Add a text box to the report where you want the words.
(Get the text box from the Tool box, opened through View menu.)

Type the expression into the Control Source property of the text box.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a toggle button on a report for when the information on the form is
inactive (eg. the client has left so their case is now inactive, ie. click
t
button) and now i need to create a report of all the clients that are
active
and inactive, but when i organise by active and inactive only numbers come
up
as the title under active or inactive and then the info follows. they
layout
is right just wanna get rid the number. Also, not that skilled in writing
instruction thingys, where bouts do i write =IIf([Inactive], "Inactive",
"Active")

You have a yes/no field named Inactive, and you want to show the word
"Inactive" instead of the -1 that Access uses when the field is true?

If so, you could place a text box on your report, and set this as its
Control Source:
=IIf([Inactive], "Inactive", "Active")

I have to create a report on a form i made. Using a wizard i want to
organise
my data so if people have clicked on a button in the form then it shows
up
first. Now i no how to organise my data by if they have clicked on the
button
or not, however, if the have clicked on the button it arranges the
information under a heading of -1, any ideas if i can get it to say
inactive
or something instead of -1. if you dont understand wat im saying ask n
il
try
to retype it. Also is there a recomended button or tick box i should
use
on
the report so that the number wont show up like -1.

 

[Allen Browne]

The request for a parameter indicates that Access cannot find the field
named "Inactive".

You need to replace the name in square brackets with the actual name of your
yes/no field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

k thanks, helpful, just 2 more things, it labels it all as inactive, even
the
unticked boxes (ie the active ones) also wat is the parameter value, it
asks
me for that when i go back into report view and dosnt change anything no
matter what i type

Open your report in design view.

Add a text box to the report where you want the words.
(Get the text box from the Tool box, opened through View menu.)

Type the expression into the Control Source property of the text box.

I have a toggle button on a report for when the information on the form
is
inactive (eg. the client has left so their case is now inactive, ie.
click
t
button) and now i need to create a report of all the clients that are
active
and inactive, but when i organise by active and inactive only numbers
come
up
as the title under active or inactive and then the info follows. they
layout
is right just wanna get rid the number. Also, not that skilled in
writing
instruction thingys, where bouts do i write =IIf([Inactive],
"Inactive",
"Active")

:

You have a yes/no field named Inactive, and you want to show the word
"Inactive" instead of the -1 that Access uses when the field is true?

If so, you could place a text box on your report, and set this as its
Control Source:
=IIf([Inactive], "Inactive", "Active")

I have to create a report on a form i made. Using a wizard i want to
organise
my data so if people have clicked on a button in the form then it
shows
up
first. Now i no how to organise my data by if they have clicked on
the
button
or not, however, if the have clicked on the button it arranges the
information under a heading of -1, any ideas if i can get it to say
inactive
or something instead of -1. if you dont understand wat im saying ask
n
il
try
to retype it. Also is there a recomended button or tick box i should
use
on
the report so that the number wont show up like -1.