Access 07 Report - Need to Count lines in a Group

= [txtCountRequests]

???

--
Clif

"TraciAnn" wrote in message
...
=Count([TicketID]) is the control source in the CreatedDate Header.

When I try to use [txtCountRequests] as the control source, it isn't
recognized. Rather, it asks for the parameter value for
"txtCountRequests".

Aaargh!!!

I've been trying what you do. Reviewing other peoples' unrelated
issues. I'm
learning allot, but I'm starting to get pressure to get this report
done.

Any other suggestions?

Thanks Clif!

--
TraciAnn


"Clif McIrvin" wrote:

"TraciAnn" wrote in message
...
John, That's PERFECT!!! Thank You!!!

I'm almost there with this issue. I finally got the right total
count
but I
also need the daily count to work, too.

Currently, on the top grouping [CreatedDate] by Day, each line
gives
me sums
of their respective data, except [Tickets] which still gives me
total
entries.

Example:
------------------------------
Date Tickets Parts
3/2/09 116 116
3/3/09 41 41
3/4/09 61 61
3/5/09 50 50
3/6/09 82 82
Total 350 350
------------------------------
txtCountTickets = 204



TraciAnn - what is the control source for Tickets? Try using
txtCountTickets as the control source.
You may need to Hide (visible = no) the Tickets control and use a new
control in it's place to get what you're after.


--
Clif






--
Clif

I'm not sure of the implication.

In the [CreatedDate] Header, when I replaced the Control Source for the
"Ticket Count" from "=Count([TicketID])" to "=Count([txtCountRequests])" It
didn't recognize it, as stated below.

If I change the control source to simply "=[txtCountRequests]" all controls
in the report return a zero value or an error except for the Ticket Count
which = 1.

I hope I'm not frustrating you by answering a question you are not asking.

--
TraciAnn


"Clif McIrvin" wrote:

= [txtCountRequests]

???

--
Clif

"TraciAnn" wrote in message
...
=Count([TicketID]) is the control source in the CreatedDate Header.

When I try to use [txtCountRequests] as the control source, it isn't
recognized. Rather, it asks for the parameter value for
"txtCountRequests".

Aaargh!!!

I've been trying what you do. Reviewing other peoples' unrelated
issues. I'm
learning allot, but I'm starting to get pressure to get this report
done.

Any other suggestions?

Thanks Clif!

--
TraciAnn


"Clif McIrvin" wrote:

"TraciAnn" wrote in message
...
John, That's PERFECT!!! Thank You!!!

I'm almost there with this issue. I finally got the right total
count
but I
also need the daily count to work, too.

Currently, on the top grouping [CreatedDate] by Day, each line
gives
me sums
of their respective data, except [Tickets] which still gives me
total
entries.

Example:
------------------------------
Date Tickets Parts
3/2/09 116 116
3/3/09 41 41
3/4/09 61 61
3/5/09 50 50
3/6/09 82 82
Total 350 350
------------------------------
txtCountTickets = 204



TraciAnn - what is the control source for Tickets? Try using
txtCountTickets as the control source.
You may need to Hide (visible = no) the Tickets control and use a new
control in it's place to get what you're after.


--
Clif






--
Clif

TraciAnn,

I believe, as per ohn's instructions, that "=Count([txtCountRequests])"
should be in the footer, is that where it is?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"TraciAnn" wrote in message
...
I'm not sure of the implication.

In the [CreatedDate] Header, when I replaced the Control Source for the
"Ticket Count" from "=Count([TicketID])" to "=Count([txtCountRequests])"
It
didn't recognize it, as stated below.

If I change the control source to simply "=[txtCountRequests]" all
controls
in the report return a zero value or an error except for the Ticket Count
which = 1.

I hope I'm not frustrating you by answering a question you are not asking.

--
TraciAnn


"Clif McIrvin" wrote:

= [txtCountRequests]

???

--
Clif

"TraciAnn" wrote in message
...
=Count([TicketID]) is the control source in the CreatedDate Header.

When I try to use [txtCountRequests] as the control source, it isn't
recognized. Rather, it asks for the parameter value for
"txtCountRequests".

Aaargh!!!

I've been trying what you do. Reviewing other peoples' unrelated
issues. I'm
learning allot, but I'm starting to get pressure to get this report
done.

Any other suggestions?

Thanks Clif!

--
TraciAnn


"Clif McIrvin" wrote:

"TraciAnn" wrote in message
...
John, That's PERFECT!!! Thank You!!!

I'm almost there with this issue. I finally got the right total
count
but I
also need the daily count to work, too.

Currently, on the top grouping [CreatedDate] by Day, each line
gives
me sums
of their respective data, except [Tickets] which still gives me
total
entries.

Example:
------------------------------
Date Tickets Parts
3/2/09 116 116
3/3/09 41 41
3/4/09 61 61
3/5/09 50 50
3/6/09 82 82
Total 350 350
------------------------------
txtCountTickets = 204



TraciAnn - what is the control source for Tickets? Try using
txtCountTickets as the control source.
You may need to Hide (visible = no) the Tickets control and use a new
control in it's place to get what you're after.


--
Clif






--
Clif

Ignore my previous post. I was testing another feature in another report and
accidently entered code into this report causing the erroneous results (duh).

Here is what I am getting using your suggestion. Keeping with the same
scenario

I have 2 Grouping levels: 1st on [CreatedDAte] by Day, 2nd on [TicketID]
which is hidden with a single text box control txtCountTickets with a value =
1.

In the Report Footer is a Control = [txtCountTickets] which produces the
Correct Total I am looking for.

As the example shows. The [CreatedDate] Header produces a total count of ALL
TicketID's per day, on the Many side of the relationship of tbleTickets &
tblParts. On the same line as my other information for each day, I need a
count of unique TicketID's just like the [txtCountTickets] is giving me.

When I add a control with =txtCountTickets in the DateCreated Header I get
the numbers in the last column of the Example.

Example:
------------------------------
Date Tickets Parts txtCountTickets
3/2/09 116 116 1
3/3/09 41 41 76
3/4/09 61 61 104
3/5/09 50 50 134
3/6/09 82 82 174
Total 350 350
------------------------------
txtCountTickets = 204

Sorry for the confusion.
--
TraciAnn


"Clif McIrvin" wrote:

= [txtCountRequests]

???

--
Clif

"TraciAnn" wrote in message
...
=Count([TicketID]) is the control source in the CreatedDate Header.

When I try to use [txtCountRequests] as the control source, it isn't
recognized. Rather, it asks for the parameter value for
"txtCountRequests".

Aaargh!!!

I've been trying what you do. Reviewing other peoples' unrelated
issues. I'm
learning allot, but I'm starting to get pressure to get this report
done.

Any other suggestions?

Thanks Clif!

--
TraciAnn


"Clif McIrvin" wrote:

"TraciAnn" wrote in message
...
John, That's PERFECT!!! Thank You!!!

I'm almost there with this issue. I finally got the right total
count
but I
also need the daily count to work, too.

Currently, on the top grouping [CreatedDate] by Day, each line
gives
me sums
of their respective data, except [Tickets] which still gives me
total
entries.

Example:
------------------------------
Date Tickets Parts
3/2/09 116 116
3/3/09 41 41
3/4/09 61 61
3/5/09 50 50
3/6/09 82 82
Total 350 350
------------------------------
txtCountTickets = 204



TraciAnn - what is the control source for Tickets? Try using
txtCountTickets as the control source.
You may need to Hide (visible = no) the Tickets control and use a new
control in it's place to get what you're after.


--
Clif






--
Clif

Gina,

Yes, it is in the footer and correctly gives me the Total count I need.
However, we are trying to get a daily record count on the same line as the
Date Grouping (Main Group). Currently, on that line it is counting every
occurrence of TicketID rather than just the unique occurrences.

Thanks Gina!
--
TraciAnn


"Gina Whipp" wrote:

TraciAnn,

I believe, as per ohn's instructions, that "=Count([txtCountRequests])"
should be in the footer, is that where it is?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"TraciAnn" wrote in message
...
I'm not sure of the implication.

In the [CreatedDate] Header, when I replaced the Control Source for the
"Ticket Count" from "=Count([TicketID])" to "=Count([txtCountRequests])"
It
didn't recognize it, as stated below.

If I change the control source to simply "=[txtCountRequests]" all
controls
in the report return a zero value or an error except for the Ticket Count
which = 1.

I hope I'm not frustrating you by answering a question you are not asking.

--
TraciAnn


"Clif McIrvin" wrote:

= [txtCountRequests]

???

--
Clif

"TraciAnn" wrote in message
...
=Count([TicketID]) is the control source in the CreatedDate Header.

When I try to use [txtCountRequests] as the control source, it isn't
recognized. Rather, it asks for the parameter value for
"txtCountRequests".

Aaargh!!!

I've been trying what you do. Reviewing other peoples' unrelated
issues. I'm
learning allot, but I'm starting to get pressure to get this report
done.

Any other suggestions?

Thanks Clif!

--
TraciAnn


"Clif McIrvin" wrote:

"TraciAnn" wrote in message
...
John, That's PERFECT!!! Thank You!!!

I'm almost there with this issue. I finally got the right total
count
but I
also need the daily count to work, too.

Currently, on the top grouping [CreatedDate] by Day, each line
gives
me sums
of their respective data, except [Tickets] which still gives me
total
entries.

Example:
------------------------------
Date Tickets Parts
3/2/09 116 116
3/3/09 41 41
3/4/09 61 61
3/5/09 50 50
3/6/09 82 82
Total 350 350
------------------------------
txtCountTickets = 204



TraciAnn - what is the control source for Tickets? Try using
txtCountTickets as the control source.
You may need to Hide (visible = no) the Tickets control and use a new
control in it's place to get what you're after.


--
Clif






--
Clif

TraciAnn --

Ah -- this does make more sense! (but .. I was nearly ready to send this
post anyway; so I just moved it over to this reply instead of the
earlier post g)

I spent a bit more time thinking this through after I saw Gina's post
....

Going back to John's suggestion, add another control:

Try the following:
-- (done) add another grouping level based on Tickets and show the group
header
-- (done) set the visible property of the group header to false (no)
--add a textbox control to the group header
-- Name: txtCountGroupTickets
-- Value: =1
-- Running Sum: OverGroup
-- In the [CreatedDAte] group footer, change the textbox control
[Tickets] and set its control
source to =[txtCountGroupTickets]

see if that gets you what you're after!

--
Clif


"TraciAnn" wrote in message
...
Ignore my previous post. I was testing another feature in another
report and
accidently entered code into this report causing the erroneous results
(duh).

Here is what I am getting using your suggestion. Keeping with the same
scenario

I have 2 Grouping levels: 1st on [CreatedDAte] by Day, 2nd on
[TicketID]
which is hidden with a single text box control txtCountTickets with a
value =
1.

In the Report Footer is a Control = [txtCountTickets] which produces
the
Correct Total I am looking for.

As the example shows. The [CreatedDate] Header produces a total count
of ALL
TicketID's per day, on the Many side of the relationship of
tbleTickets &
tblParts. On the same line as my other information for each day, I
need a
count of unique TicketID's just like the [txtCountTickets] is giving
me.

When I add a control with =txtCountTickets in the DateCreated Header I
get
the numbers in the last column of the Example.

Example:
------------------------------
Date Tickets Parts txtCountTickets
3/2/09 116 116 1
3/3/09 41 41 76
3/4/09 61 61 104
3/5/09 50 50 134
3/6/09 82 82 174
Total 350 350
------------------------------
txtCountTickets = 204

Sorry for the confusion.
--
TraciAnn





--
Clif

Drink more coffee... :-)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"TraciAnn" wrote in message
...
Gina,

Yes, it is in the footer and correctly gives me the Total count I need.
However, we are trying to get a daily record count on the same line as the
Date Grouping (Main Group). Currently, on that line it is counting every
occurrence of TicketID rather than just the unique occurrences.

Thanks Gina!
--
TraciAnn


"Gina Whipp" wrote:

TraciAnn,

I believe, as per ohn's instructions, that "=Count([txtCountRequests])"
should be in the footer, is that where it is?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"TraciAnn" wrote in message
...
I'm not sure of the implication.

In the [CreatedDate] Header, when I replaced the Control Source for the
"Ticket Count" from "=Count([TicketID])" to
"=Count([txtCountRequests])"
It
didn't recognize it, as stated below.

If I change the control source to simply "=[txtCountRequests]" all
controls
in the report return a zero value or an error except for the Ticket
Count
which = 1.

I hope I'm not frustrating you by answering a question you are not
asking.

--
TraciAnn


"Clif McIrvin" wrote:

= [txtCountRequests]

???

--
Clif

"TraciAnn" wrote in message
...
=Count([TicketID]) is the control source in the CreatedDate Header.

When I try to use [txtCountRequests] as the control source, it isn't
recognized. Rather, it asks for the parameter value for
"txtCountRequests".

Aaargh!!!

I've been trying what you do. Reviewing other peoples' unrelated
issues. I'm
learning allot, but I'm starting to get pressure to get this report
done.

Any other suggestions?

Thanks Clif!

--
TraciAnn


"Clif McIrvin" wrote:

"TraciAnn" wrote in message
...
John, That's PERFECT!!! Thank You!!!

I'm almost there with this issue. I finally got the right total
count
but I
also need the daily count to work, too.

Currently, on the top grouping [CreatedDate] by Day, each line
gives
me sums
of their respective data, except [Tickets] which still gives me
total
entries.

Example:
------------------------------
Date Tickets Parts
3/2/09 116 116
3/3/09 41 41
3/4/09 61 61
3/5/09 50 50
3/6/09 82 82
Total 350 350
------------------------------
txtCountTickets = 204



TraciAnn - what is the control source for Tickets? Try using
txtCountTickets as the control source.
You may need to Hide (visible = no) the Tickets control and use a
new
control in it's place to get what you're after.


--
Clif






--
Clif

Clif, This is going in the wrong direction.

Following your addition to John's solution, an additional line was inserted
to each daily line with a value of "1".

Therefore, my example looked like this:
--------------
Date Tickets Parts txtCountTickets
3/2/09 116 116 1
1
3/3/09 41 41 76
1
3/4/09 61 61 104
1
3/5/09 50 50 134
1
3/6/09 82 82 174
1
Total 350 350
------------------------------
txtCountTickets = 204

Trying to keep focus, the example should look like this:
---------
Date Tickets Parts txtCountTickets
3/2/09 74 116 1
3/3/09 27 41 76
3/4/09 28 61 104
3/5/09 41 50 134
3/6/09 34 82 174
Total 204 350
------------------------------
Notice that the 2nd column totals changed to equal the total number of
Unique TicketIDs for each day.

Thanks Guys!!! Your efforts are greatly appreciated!

--
TraciAnn


"Clif McIrvin" wrote:

TraciAnn --

Ah -- this does make more sense! (but .. I was nearly ready to send this
post anyway; so I just moved it over to this reply instead of the
earlier post g)

I spent a bit more time thinking this through after I saw Gina's post
....

Going back to John's suggestion, add another control:

Try the following:
-- (done) add another grouping level based on Tickets and show the group
header
-- (done) set the visible property of the group header to false (no)
--add a textbox control to the group header
-- Name: txtCountGroupTickets
-- Value: =1
-- Running Sum: OverGroup
-- In the [CreatedDAte] group footer, change the textbox control
[Tickets] and set its control
source to =[txtCountGroupTickets]

see if that gets you what you're after!

--
Clif


"TraciAnn" wrote in message
...
Ignore my previous post. I was testing another feature in another
report and
accidently entered code into this report causing the erroneous results
(duh).

Here is what I am getting using your suggestion. Keeping with the same
scenario

I have 2 Grouping levels: 1st on [CreatedDAte] by Day, 2nd on
[TicketID]
which is hidden with a single text box control txtCountTickets with a
value =
1.

In the Report Footer is a Control = [txtCountTickets] which produces
the
Correct Total I am looking for.

As the example shows. The [CreatedDate] Header produces a total count
of ALL
TicketID's per day, on the Many side of the relationship of
tbleTickets &
tblParts. On the same line as my other information for each day, I
need a
count of unique TicketID's just like the [txtCountTickets] is giving
me.

When I add a control with =txtCountTickets in the DateCreated Header I
get
the numbers in the last column of the Example.

Example:
------------------------------
Date Tickets Parts txtCountTickets
3/2/09 116 116 1
3/3/09 41 41 76
3/4/09 61 61 104
3/5/09 50 50 134
3/6/09 82 82 174
Total 350 350
------------------------------
txtCountTickets = 204

Sorry for the confusion.
--
TraciAnn





--
Clif

It's going to be a while before I can get back to this ... your two
examples below do help.

Hopefully someone else can jump in and help out.

--
Clif

"TraciAnn" wrote in message
...
Clif, This is going in the wrong direction.

Following your addition to John's solution, an additional line was
inserted
to each daily line with a value of "1".

Therefore, my example looked like this:
--------------
Date Tickets Parts txtCountTickets
3/2/09 116 116 1
1
3/3/09 41 41 76
1
3/4/09 61 61 104
1
3/5/09 50 50 134
1
3/6/09 82 82 174
1
Total 350 350
------------------------------
txtCountTickets = 204

Trying to keep focus, the example should look like this:
---------
Date Tickets Parts txtCountTickets
3/2/09 74 116 1
3/3/09 27 41 76
3/4/09 28 61 104
3/5/09 41 50 134
3/6/09 34 82 174
Total 204 350
------------------------------
Notice that the 2nd column totals changed to equal the total number of
Unique TicketIDs for each day.

Thanks Guys!!! Your efforts are greatly appreciated!

--
TraciAnn


"Clif McIrvin" wrote:

TraciAnn --

Ah -- this does make more sense! (but .. I was nearly ready to send
this
post anyway; so I just moved it over to this reply instead of the
earlier post g)

I spent a bit more time thinking this through after I saw Gina's post
....

Going back to John's suggestion, add another control:

Try the following:
-- (done) add another grouping level based on Tickets and show the
group
header
-- (done) set the visible property of the group header to false (no)
--add a textbox control to the group header
-- Name: txtCountGroupTickets
-- Value: =1
-- Running Sum: OverGroup
-- In the [CreatedDAte] group footer, change the textbox control
[Tickets] and set its control
source to =[txtCountGroupTickets]

see if that gets you what you're after!

--
Clif


"TraciAnn" wrote in message
...
Ignore my previous post. I was testing another feature in another
report and
accidently entered code into this report causing the erroneous
results
(duh).

Here is what I am getting using your suggestion. Keeping with the
same
scenario

I have 2 Grouping levels: 1st on [CreatedDAte] by Day, 2nd on
[TicketID]
which is hidden with a single text box control txtCountTickets with
a
value =
1.

In the Report Footer is a Control = [txtCountTickets] which
produces
the
Correct Total I am looking for.

As the example shows. The [CreatedDate] Header produces a total
count
of ALL
TicketID's per day, on the Many side of the relationship of
tbleTickets &
tblParts. On the same line as my other information for each day, I
need a
count of unique TicketID's just like the [txtCountTickets] is
giving
me.

When I add a control with =txtCountTickets in the DateCreated
Header I
get
the numbers in the last column of the Example.

Example:
------------------------------
Date Tickets Parts txtCountTickets
3/2/09 116 116 1
3/3/09 41 41 76
3/4/09 61 61 104
3/5/09 50 50 134
3/6/09 82 82 174
Total 350 350
------------------------------
txtCountTickets = 204

Sorry for the confusion.
--
TraciAnn





--
Clif






--
Clif

Oops....The example should NOT have the last column "txtCountTickets" I
forgot to take that out.

--
TraciAnn


"TraciAnn" wrote:

Clif, This is going in the wrong direction.

Following your addition to John's solution, an additional line was inserted
to each daily line with a value of "1".

Therefore, my example looked like this:
--------------
Date Tickets Parts txtCountTickets
3/2/09 116 116 1
1
3/3/09 41 41 76
1
3/4/09 61 61 104
1
3/5/09 50 50 134
1
3/6/09 82 82 174
1
Total 350 350
------------------------------
txtCountTickets = 204

Trying to keep focus, the example should look like this:
---------
Date Tickets Parts txtCountTickets
3/2/09 74 116 1
3/3/09 27 41 76
3/4/09 28 61 104
3/5/09 41 50 134
3/6/09 34 82 174
Total 204 350
------------------------------
Notice that the 2nd column totals changed to equal the total number of
Unique TicketIDs for each day.

Thanks Guys!!! Your efforts are greatly appreciated!

--
TraciAnn


"Clif McIrvin" wrote:

TraciAnn --

Ah -- this does make more sense! (but .. I was nearly ready to send this
post anyway; so I just moved it over to this reply instead of the
earlier post g)

I spent a bit more time thinking this through after I saw Gina's post
....

Going back to John's suggestion, add another control:

Try the following:
-- (done) add another grouping level based on Tickets and show the group
header
-- (done) set the visible property of the group header to false (no)
--add a textbox control to the group header
-- Name: txtCountGroupTickets
-- Value: =1
-- Running Sum: OverGroup
-- In the [CreatedDAte] group footer, change the textbox control
[Tickets] and set its control
source to =[txtCountGroupTickets]

see if that gets you what you're after!

--
Clif


"TraciAnn" wrote in message
...
Ignore my previous post. I was testing another feature in another
report and
accidently entered code into this report causing the erroneous results
(duh).

Here is what I am getting using your suggestion. Keeping with the same
scenario

I have 2 Grouping levels: 1st on [CreatedDAte] by Day, 2nd on
[TicketID]
which is hidden with a single text box control txtCountTickets with a
value =
1.

In the Report Footer is a Control = [txtCountTickets] which produces
the
Correct Total I am looking for.

As the example shows. The [CreatedDate] Header produces a total count
of ALL
TicketID's per day, on the Many side of the relationship of
tbleTickets &
tblParts. On the same line as my other information for each day, I
need a
count of unique TicketID's just like the [txtCountTickets] is giving
me.

When I add a control with =txtCountTickets in the DateCreated Header I
get
the numbers in the last column of the Example.

Example:
------------------------------
Date Tickets Parts txtCountTickets
3/2/09 116 116 1
3/3/09 41 41 76
3/4/09 61 61 104
3/5/09 50 50 134
3/6/09 82 82 174
Total 350 350
------------------------------
txtCountTickets = 204

Sorry for the confusion.
--
TraciAnn





--
Clif