count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I added a Sorting & Grouping to my report. Now I'm trying to add a text box
in the grouped footer and then a =Sum(...) in the Report footer.
I think I need something like:
"SELECT DISTINCTROW q_KeyIndicators.NumCases " & _
in the VB code, but I'm not really sure where to start???

Dan
 
Guess I did not explain the most important part I don't have a numeric field
to count the cases returned.
I need to count the number of cases returned in the group by footer.
Then a grand total in the report footer.

If I had a numeric value called "numcase" I could just add:
group footer = [numcases]
report footer = =Sum([numCases])

My question is how can I count the cases returned.
I'm assuming it would be something like what I put in the origanal message...

Thanks




Duane Hookom said:
What's wrong with using:
=Sum([Your Numeric Field Name])


--
Duane Hookom
MS Access MVP

Dan @BCBS said:
I added a Sorting & Grouping to my report. Now I'm trying to add a text
box
in the grouped footer and then a =Sum(...) in the Report footer.
I think I need something like:
"SELECT DISTINCTROW q_KeyIndicators.NumCases " & _
in the VB code, but I'm not really sure where to start???

Dan
Click to expand...
Click to expand...
 
You have told us what you don't have but we have no clue what you do have.
Could you take the time to type some significant data into a reply so we can
understand?

--
Duane Hookom
MS Access MVP


Dan @BCBS said:
Guess I did not explain the most important part I don't have a numeric
field
to count the cases returned.
I need to count the number of cases returned in the group by footer.
Then a grand total in the report footer.

If I had a numeric value called "numcase" I could just add:
group footer = [numcases]
report footer = =Sum([numCases])

My question is how can I count the cases returned.
I'm assuming it would be something like what I put in the origanal
message...

Thanks




Duane Hookom said:
What's wrong with using:
=Sum([Your Numeric Field Name])


--
Duane Hookom
MS Access MVP

Dan @BCBS said:
I added a Sorting & Grouping to my report. Now I'm trying to add a text
box
in the grouped footer and then a =Sum(...) in the Report footer.
I think I need something like:
"SELECT DISTINCTROW q_KeyIndicators.NumCases " & _
in the VB code, but I'm not really sure where to start???

Dan
Click to expand...
Click to expand...
Click to expand...
 
If your expecting the VB code, I have not created any for this report, I'm
not sure what else I have that could explain it any better.

All I want to do is count the number of contracts returned on the report !!!!

Dan




Duane Hookom said:
You have told us what you don't have but we have no clue what you do have.
Could you take the time to type some significant data into a reply so we can
understand?

--
Duane Hookom
MS Access MVP


Dan @BCBS said:
Guess I did not explain the most important part I don't have a numeric
field
to count the cases returned.
I need to count the number of cases returned in the group by footer.
Then a grand total in the report footer.

If I had a numeric value called "numcase" I could just add:
group footer = [numcases]
report footer = =Sum([numCases])

My question is how can I count the cases returned.
I'm assuming it would be something like what I put in the origanal
message...

Thanks




Duane Hookom said:
What's wrong with using:
=Sum([Your Numeric Field Name])


--
Duane Hookom
MS Access MVP

I added a Sorting & Grouping to my report. Now I'm trying to add a text
box
in the grouped footer and then a =Sum(...) in the Report footer.
I think I need something like:
"SELECT DISTINCTROW q_KeyIndicators.NumCases " & _
in the VB code, but I'm not really sure where to start???

Dan
Click to expand...
Click to expand...
Click to expand...
 
Your earlier mention of "=Sum(...)" and "NumCases" caused me to think you
wanted to sum the number of cases. If all you want to do is count, then use:

=Count([Numcases])


--
Duane Hookom
MS Access MVP

Dan @BCBS said:
If your expecting the VB code, I have not created any for this report, I'm
not sure what else I have that could explain it any better.

All I want to do is count the number of contracts returned on the report
!!!!

Dan




Duane Hookom said:
You have told us what you don't have but we have no clue what you do
have.
Could you take the time to type some significant data into a reply so we
can
understand?

--
Duane Hookom
MS Access MVP


Dan @BCBS said:
Guess I did not explain the most important part I don't have a numeric
field
to count the cases returned.
I need to count the number of cases returned in the group by footer.
Then a grand total in the report footer.

If I had a numeric value called "numcase" I could just add:
group footer = [numcases]
report footer = =Sum([numCases])

My question is how can I count the cases returned.
I'm assuming it would be something like what I put in the origanal
message...

Thanks




:

What's wrong with using:
=Sum([Your Numeric Field Name])


--
Duane Hookom
MS Access MVP

I added a Sorting & Grouping to my report. Now I'm trying to add a
text
box
in the grouped footer and then a =Sum(...) in the Report footer.
I think I need something like:
"SELECT DISTINCTROW q_KeyIndicators.NumCases " & _
in the VB code, but I'm not really sure where to start???

Dan
Click to expand...
Click to expand...
Click to expand...
 
I appoligise, I'm having a difficult time explaining what I need, I think it
may be because it's a very simple question !

I used "Numcases" as an example. I do not have a value called Numcases.
my report has employees and employee numbers. I need to count the number of
employees returned in the grouped footer.

Once I do that, I can add the sum in the report footer.

Thanks


Duane Hookom said:
Your earlier mention of "=Sum(...)" and "NumCases" caused me to think you
wanted to sum the number of cases. If all you want to do is count, then use:

=Count([Numcases])


--
Duane Hookom
MS Access MVP

Dan @BCBS said:
If your expecting the VB code, I have not created any for this report, I'm
not sure what else I have that could explain it any better.

All I want to do is count the number of contracts returned on the report
!!!!

Dan




Duane Hookom said:
You have told us what you don't have but we have no clue what you do
have.
Could you take the time to type some significant data into a reply so we
can
understand?

--
Duane Hookom
MS Access MVP


Guess I did not explain the most important part I don't have a numeric
field
to count the cases returned.
I need to count the number of cases returned in the group by footer.
Then a grand total in the report footer.

If I had a numeric value called "numcase" I could just add:
group footer = [numcases]
report footer = =Sum([numCases])

My question is how can I count the cases returned.
I'm assuming it would be something like what I put in the origanal
message...

Thanks




:

What's wrong with using:
=Sum([Your Numeric Field Name])


--
Duane Hookom
MS Access MVP

I added a Sorting & Grouping to my report. Now I'm trying to add a
text
box
in the grouped footer and then a =Sum(...) in the Report footer.
I think I need something like:
"SELECT DISTINCTROW q_KeyIndicators.NumCases " & _
in the VB code, but I'm not really sure where to start???

Dan
Click to expand...
Click to expand...
Click to expand...
 
You can use any field in the Count() as long is the field might not be null.
You could use:
=Count(1)
=Count(*)
=Sum(1)
=Count("any expression")

--
Duane Hookom
MS Access MVP


Dan @BCBS said:
I appoligise, I'm having a difficult time explaining what I need, I think
it
may be because it's a very simple question !

I used "Numcases" as an example. I do not have a value called Numcases.
my report has employees and employee numbers. I need to count the number
of
employees returned in the grouped footer.

Once I do that, I can add the sum in the report footer.

Thanks


Duane Hookom said:
Your earlier mention of "=Sum(...)" and "NumCases" caused me to think you
wanted to sum the number of cases. If all you want to do is count, then
use:

=Count([Numcases])


--
Duane Hookom
MS Access MVP

Dan @BCBS said:
If your expecting the VB code, I have not created any for this report,
I'm
not sure what else I have that could explain it any better.

All I want to do is count the number of contracts returned on the
report
!!!!

Dan




:

You have told us what you don't have but we have no clue what you do
have.
Could you take the time to type some significant data into a reply so
we
can
understand?

--
Duane Hookom
MS Access MVP


Guess I did not explain the most important part I don't have a
numeric
field
to count the cases returned.
I need to count the number of cases returned in the group by footer.
Then a grand total in the report footer.

If I had a numeric value called "numcase" I could just add:
group footer = [numcases]
report footer = =Sum([numCases])

My question is how can I count the cases returned.
I'm assuming it would be something like what I put in the origanal
message...

Thanks




:

What's wrong with using:
=Sum([Your Numeric Field Name])


--
Duane Hookom
MS Access MVP

I added a Sorting & Grouping to my report. Now I'm trying to add
a
text
box
in the grouped footer and then a =Sum(...) in the Report footer.
I think I need something like:
"SELECT DISTINCTROW q_KeyIndicators.NumCases " & _
in the VB code, but I'm not really sure where to start???

Dan
Click to expand...
Click to expand...
Click to expand...
 
That's it, Thanks you

Duane Hookom said:
You can use any field in the Count() as long is the field might not be null.
You could use:
=Count(1)
=Count(*)
=Sum(1)
=Count("any expression")

--
Duane Hookom
MS Access MVP


Dan @BCBS said:
I appoligise, I'm having a difficult time explaining what I need, I think
it
may be because it's a very simple question !

I used "Numcases" as an example. I do not have a value called Numcases.
my report has employees and employee numbers. I need to count the number
of
employees returned in the grouped footer.

Once I do that, I can add the sum in the report footer.

Thanks


Duane Hookom said:
Your earlier mention of "=Sum(...)" and "NumCases" caused me to think you
wanted to sum the number of cases. If all you want to do is count, then
use:

=Count([Numcases])


--
Duane Hookom
MS Access MVP

If your expecting the VB code, I have not created any for this report,
I'm
not sure what else I have that could explain it any better.

All I want to do is count the number of contracts returned on the
report
!!!!

Dan




:

You have told us what you don't have but we have no clue what you do
have.
Could you take the time to type some significant data into a reply so
we
can
understand?

--
Duane Hookom
MS Access MVP


Guess I did not explain the most important part I don't have a
numeric
field
to count the cases returned.
I need to count the number of cases returned in the group by footer.
Then a grand total in the report footer.

If I had a numeric value called "numcase" I could just add:
group footer = [numcases]
report footer = =Sum([numCases])

My question is how can I count the cases returned.
I'm assuming it would be something like what I put in the origanal
message...

Thanks




:

What's wrong with using:
=Sum([Your Numeric Field Name])


--
Duane Hookom
MS Access MVP

I added a Sorting & Grouping to my report. Now I'm trying to add
a
text
box
in the grouped footer and then a =Sum(...) in the Report footer.
I think I need something like:
"SELECT DISTINCTROW q_KeyIndicators.NumCases " & _
in the VB code, but I'm not really sure where to start???

Dan
Click to expand...
Click to expand...
Click to expand...
 
That's it, thank you....



Duane Hookom said:
You can use any field in the Count() as long is the field might not be null.
You could use:
=Count(1)
=Count(*)
=Sum(1)
=Count("any expression")

--
Duane Hookom
MS Access MVP


Dan @BCBS said:
I appoligise, I'm having a difficult time explaining what I need, I think
it
may be because it's a very simple question !

I used "Numcases" as an example. I do not have a value called Numcases.
my report has employees and employee numbers. I need to count the number
of
employees returned in the grouped footer.

Once I do that, I can add the sum in the report footer.

Thanks


Duane Hookom said:
Your earlier mention of "=Sum(...)" and "NumCases" caused me to think you
wanted to sum the number of cases. If all you want to do is count, then
use:

=Count([Numcases])


--
Duane Hookom
MS Access MVP

If your expecting the VB code, I have not created any for this report,
I'm
not sure what else I have that could explain it any better.

All I want to do is count the number of contracts returned on the
report
!!!!

Dan




:

You have told us what you don't have but we have no clue what you do
have.
Could you take the time to type some significant data into a reply so
we
can
understand?

--
Duane Hookom
MS Access MVP


Guess I did not explain the most important part I don't have a
numeric
field
to count the cases returned.
I need to count the number of cases returned in the group by footer.
Then a grand total in the report footer.

If I had a numeric value called "numcase" I could just add:
group footer = [numcases]
report footer = =Sum([numCases])

My question is how can I count the cases returned.
I'm assuming it would be something like what I put in the origanal
message...

Thanks




:

What's wrong with using:
=Sum([Your Numeric Field Name])


--
Duane Hookom
MS Access MVP

I added a Sorting & Grouping to my report. Now I'm trying to add
a
text
box
in the grouped footer and then a =Sum(...) in the Report footer.
I think I need something like:
"SELECT DISTINCTROW q_KeyIndicators.NumCases " & _
in the VB code, but I'm not really sure where to start???

Dan
Click to expand...
Click to expand...
Click to expand...
 
One more question:
If I use =Count(1) in the grouped footer what do I use in the Report footer
because count is not really a value I can pass down...???

Thanks

Duane Hookom said:
You can use any field in the Count() as long is the field might not be null.
You could use:
=Count(1)
=Count(*)
=Sum(1)
=Count("any expression")

--
Duane Hookom
MS Access MVP


Dan @BCBS said:
I appoligise, I'm having a difficult time explaining what I need, I think
it
may be because it's a very simple question !

I used "Numcases" as an example. I do not have a value called Numcases.
my report has employees and employee numbers. I need to count the number
of
employees returned in the grouped footer.

Once I do that, I can add the sum in the report footer.

Thanks


Duane Hookom said:
Your earlier mention of "=Sum(...)" and "NumCases" caused me to think you
wanted to sum the number of cases. If all you want to do is count, then
use:

=Count([Numcases])


--
Duane Hookom
MS Access MVP

If your expecting the VB code, I have not created any for this report,
I'm
not sure what else I have that could explain it any better.

All I want to do is count the number of contracts returned on the
report
!!!!

Dan




:

You have told us what you don't have but we have no clue what you do
have.
Could you take the time to type some significant data into a reply so
we
can
understand?

--
Duane Hookom
MS Access MVP


Guess I did not explain the most important part I don't have a
numeric
field
to count the cases returned.
I need to count the number of cases returned in the group by footer.
Then a grand total in the report footer.

If I had a numeric value called "numcase" I could just add:
group footer = [numcases]
report footer = =Sum([numCases])

My question is how can I count the cases returned.
I'm assuming it would be something like what I put in the origanal
message...

Thanks




:

What's wrong with using:
=Sum([Your Numeric Field Name])


--
Duane Hookom
MS Access MVP

I added a Sorting & Grouping to my report. Now I'm trying to add
a
text
box
in the grouped footer and then a =Sum(...) in the Report footer.
I think I need something like:
"SELECT DISTINCTROW q_KeyIndicators.NumCases " & _
in the VB code, but I'm not really sure where to start???

Dan
Click to expand...
Click to expand...
Click to expand...
 
In your report footer, try
=Count(1)


--
Duane Hookom
MS Access MVP

Dan @BCBS said:
One more question:
If I use =Count(1) in the grouped footer what do I use in the Report
footer
because count is not really a value I can pass down...???

Thanks

Duane Hookom said:
You can use any field in the Count() as long is the field might not be
null.
You could use:
=Count(1)
=Count(*)
=Sum(1)
=Count("any expression")

--
Duane Hookom
MS Access MVP


Dan @BCBS said:
I appoligise, I'm having a difficult time explaining what I need, I
think
it
may be because it's a very simple question !

I used "Numcases" as an example. I do not have a value called
Numcases.
my report has employees and employee numbers. I need to count the
number
of
employees returned in the grouped footer.

Once I do that, I can add the sum in the report footer.

Thanks


:

Your earlier mention of "=Sum(...)" and "NumCases" caused me to think
you
wanted to sum the number of cases. If all you want to do is count,
then
use:

=Count([Numcases])


--
Duane Hookom
MS Access MVP

If your expecting the VB code, I have not created any for this
report,
I'm
not sure what else I have that could explain it any better.

All I want to do is count the number of contracts returned on the
report
!!!!

Dan




:

You have told us what you don't have but we have no clue what you
do
have.
Could you take the time to type some significant data into a reply
so
we
can
understand?

--
Duane Hookom
MS Access MVP


Guess I did not explain the most important part I don't have a
numeric
field
to count the cases returned.
I need to count the number of cases returned in the group by
footer.
Then a grand total in the report footer.

If I had a numeric value called "numcase" I could just add:
group footer = [numcases]
report footer = =Sum([numCases])

My question is how can I count the cases returned.
I'm assuming it would be something like what I put in the
origanal
message...

Thanks




:

What's wrong with using:
=Sum([Your Numeric Field Name])


--
Duane Hookom
MS Access MVP

I added a Sorting & Grouping to my report. Now I'm trying to
add
a
text
box
in the grouped footer and then a =Sum(...) in the Report
footer.
I think I need something like:
"SELECT DISTINCTROW q_KeyIndicators.NumCases " & _
in the VB code, but I'm not really sure where to start???

Dan
Click to expand...
Click to expand...
Click to expand...
 
Back
Top