Label Question

[scott04]

I have a report that is grouped by lawsuit type. Example Civil, Class
Action. In the lawsuit_type footer I have a count that counts each group.
The current label is Lawsuit Type Count. Is there a way so myb label can say
Civil Count and then for the section with Class Action say Class Action
count? I am not sure of the syntax. Any help or suggestions is appreciated.

 

[Duane Hookom]

Change the label to a text box and set the control source to something like:
=[LawsuitType] & " Count"

 

[scott04]

Duane,
I have added a text book as advised and it is only creating a count of 1
even when there maybe 10. I placed the textbox in the Lawsuit_type footer.

Change the label to a text box and set the control source to something like:
=[LawsuitType] & " Count"
--
Duane Hookom
Microsoft Access MVP

I have a report that is grouped by lawsuit type. Example Civil, Class
Action. In the lawsuit_type footer I have a count that counts each group.
The current label is Lawsuit Type Count. Is there a way so myb label can say
Civil Count and then for the section with Class Action say Class Action
count? I am not sure of the syntax. Any help or suggestions is appreciated.

 

[Duane Hookom]

The text box you asked for just replaced the label. It didn't have anything
to do with the actual counting of anything. If you want it to display bothe
the Lawsuit Type and the actual count, try a control source of:
=[LawsuitType] & " Count: " & Count(*)

--
Duane Hookom
Microsoft Access MVP

Duane,
I have added a text book as advised and it is only creating a count of 1
even when there maybe 10. I placed the textbox in the Lawsuit_type footer.

Change the label to a text box and set the control source to something like:
=[LawsuitType] & " Count"
--
Duane Hookom
Microsoft Access MVP

I have a report that is grouped by lawsuit type. Example Civil, Class
Action. In the lawsuit_type footer I have a count that counts each group.
The current label is Lawsuit Type Count. Is there a way so myb label can say
Civil Count and then for the section with Class Action say Class Action
count? I am not sure of the syntax. Any help or suggestions is appreciated.

 

[scott04]

Duane,
The only problem i have is the report is grabbing the number assigned to
lawsuit_type instead of the text small claims ect.......my tbl_lawsuit_type
is setup for example 1 small claims 2 civil 3 class action. When my query
runs it grabs small claims but when i use this formula: =[LawsuitType] & "
Count: " & Count(*), it gives me 1 count and then then number of small
claims. Can you assist?

The text box you asked for just replaced the label. It didn't have anything
to do with the actual counting of anything. If you want it to display bothe
the Lawsuit Type and the actual count, try a control source of:
=[LawsuitType] & " Count: " & Count(*)

--
Duane Hookom
Microsoft Access MVP

Duane,
I have added a text book as advised and it is only creating a count of 1
even when there maybe 10. I placed the textbox in the Lawsuit_type footer.

Change the label to a text box and set the control source to something like:
=[LawsuitType] & " Count"
--
Duane Hookom
Microsoft Access MVP


:

I have a report that is grouped by lawsuit type. Example Civil, Class
Action. In the lawsuit_type footer I have a count that counts each group.
The current label is Lawsuit Type Count. Is there a way so myb label can say
Civil Count and then for the section with Class Action say Class Action
count? I am not sure of the syntax. Any help or suggestions is appreciated.

 

[Duane Hookom]

Apparently you used a dreaded (IMHO) lookup field defined in a table. Add
tbl_lawsuit_type to your report's recordsource and use the description/title
field rather than the number field.
--
Duane Hookom
Microsoft Access MVP

Duane,
The only problem i have is the report is grabbing the number assigned to
lawsuit_type instead of the text small claims ect.......my tbl_lawsuit_type
is setup for example 1 small claims 2 civil 3 class action. When my query
runs it grabs small claims but when i use this formula: =[LawsuitType] & "
Count: " & Count(*), it gives me 1 count and then then number of small
claims. Can you assist?

The text box you asked for just replaced the label. It didn't have anything
to do with the actual counting of anything. If you want it to display bothe
the Lawsuit Type and the actual count, try a control source of:
=[LawsuitType] & " Count: " & Count(*)

--
Duane Hookom
Microsoft Access MVP

Duane,
I have added a text book as advised and it is only creating a count of 1
even when there maybe 10. I placed the textbox in the Lawsuit_type footer.

:

Change the label to a text box and set the control source to something like:
=[LawsuitType] & " Count"
--
Duane Hookom
Microsoft Access MVP


:

I have a report that is grouped by lawsuit type. Example Civil, Class
Action. In the lawsuit_type footer I have a count that counts each group.
The current label is Lawsuit Type Count. Is there a way so myb label can say
Civil Count and then for the section with Class Action say Class Action
count? I am not sure of the syntax. Any help or suggestions is appreciated.

 

[scott04]

Thanks. Can you add more than one recordsource in a report?

Apparently you used a dreaded (IMHO) lookup field defined in a table. Add
tbl_lawsuit_type to your report's recordsource and use the description/title
field rather than the number field.
--
Duane Hookom
Microsoft Access MVP

Duane,
The only problem i have is the report is grabbing the number assigned to
lawsuit_type instead of the text small claims ect.......my tbl_lawsuit_type
is setup for example 1 small claims 2 civil 3 class action. When my query
runs it grabs small claims but when i use this formula: =[LawsuitType] & "
Count: " & Count(*), it gives me 1 count and then then number of small
claims. Can you assist?

The text box you asked for just replaced the label. It didn't have anything
to do with the actual counting of anything. If you want it to display bothe
the Lawsuit Type and the actual count, try a control source of:
=[LawsuitType] & " Count: " & Count(*)

--
Duane Hookom
Microsoft Access MVP


:

Duane,
I have added a text book as advised and it is only creating a count of 1
even when there maybe 10. I placed the textbox in the Lawsuit_type footer.

:

Change the label to a text box and set the control source to something like:
=[LawsuitType] & " Count"
--
Duane Hookom
Microsoft Access MVP


:

I have a report that is grouped by lawsuit type. Example Civil, Class
Action. In the lawsuit_type footer I have a count that counts each group.
The current label is Lawsuit Type Count. Is there a way so myb label can say
Civil Count and then for the section with Class Action say Class Action
count? I am not sure of the syntax. Any help or suggestions is appreciated.

 

[scott04]

Sorry Duane I had a brainfreeze for the moment and now understand what you
are saying.....thanks for all your help it works now!!

Apparently you used a dreaded (IMHO) lookup field defined in a table. Add
tbl_lawsuit_type to your report's recordsource and use the description/title
field rather than the number field.
--
Duane Hookom
Microsoft Access MVP

Duane,
The only problem i have is the report is grabbing the number assigned to
lawsuit_type instead of the text small claims ect.......my tbl_lawsuit_type
is setup for example 1 small claims 2 civil 3 class action. When my query
runs it grabs small claims but when i use this formula: =[LawsuitType] & "
Count: " & Count(*), it gives me 1 count and then then number of small
claims. Can you assist?

The text box you asked for just replaced the label. It didn't have anything
to do with the actual counting of anything. If you want it to display bothe
the Lawsuit Type and the actual count, try a control source of:
=[LawsuitType] & " Count: " & Count(*)

--
Duane Hookom
Microsoft Access MVP


:

Duane,
I have added a text book as advised and it is only creating a count of 1
even when there maybe 10. I placed the textbox in the Lawsuit_type footer.

:

Change the label to a text box and set the control source to something like:
=[LawsuitType] & " Count"
--
Duane Hookom
Microsoft Access MVP


:

I have a report that is grouped by lawsuit type. Example Civil, Class
Action. In the lawsuit_type footer I have a count that counts each group.
The current label is Lawsuit Type Count. Is there a way so myb label can say
Civil Count and then for the section with Class Action say Class Action
count? I am not sure of the syntax. Any help or suggestions is appreciated.