Access 07 Report - Need to Count lines in a Group

[TraciAnn]

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

= [txtCountRequests]

???

--
Clif

=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

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.

 

[TraciAnn]

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

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

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

= [txtCountRequests]

???

--
Clif

=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


:

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.

 

[TraciAnn]

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

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

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

= [txtCountRequests]

???

--
Clif

=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


:

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 McIrvin]

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

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

 

[Clif McIrvin]

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

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

 

[Gina Whipp]

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

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

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

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


:

= [txtCountRequests]

???

--
Clif

=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


:

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.

 

[Gina Whipp]

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

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

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

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


:

= [txtCountRequests]

???

--
Clif

=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


:

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.

 

[TraciAnn]

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

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

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

 

[TraciAnn]

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

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

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

 

[Clif McIrvin]

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

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

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

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

 

[Clif McIrvin]

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

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

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

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

 

[TraciAnn]

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

--
TraciAnn

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

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

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

 

[TraciAnn]

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

--
TraciAnn

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

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

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

 

[Clif McIrvin]

TraciAnn -- I think I have got it figured out.

Think "I need to count sub-groups", not "I need to count Tickets."

Using some of my data, I have come up with this:


Date Location Items
.... this is page 8 ........
2/23/2009 2 3
2/24/2009 4 2
2/25/2009 2 4
2/26/2009 2 2
3/2/2009 1 2
3/3/2009 2 2
3/4/2009 2 4
3/5/2009 1 6
3/6/2009 1 10
12/18/2009 1 2

Totals 483 1161

I counted the records using a select query, and the totals are correct.

You will need eight unbound text boxes and two groups to get the totals
you want.

I think you have the groups working as you need, we just need to get the
running sums doing what you want.

On the Detail section you need two unbound text boxes:
--- Name: txtPartsInGroup txtPartsAll
--- Control Source: =1 =1
--- Running Sum: Over Group Over All

On the Tickets (hidden) group header you need two unbound text boxes:
--- Name: txtTicketsInGroup txtTicketsAll
--- Control Source: =1 =1
--- Running Sum: Over Group Over All

On the Date Footer you have two unbound text boxes:
--- Control Source: txtTicketsInGroup txtPartsInGroup
--- Running Sum: No No

On the Report Footer you have two unbound text boxes:
--- Control Source: txtTicketsAll txtPartsAll
--- Running Sum: No No

(You already have Date behaving itself, so I didn't count it <g>.)

 

[TraciAnn]

I think we are almost there!

Using your directions I am getting the Over All number of Tickets, but I'm
still not getting the number of (unique) Tickets per day.

Going back to the example, this is what I'm getting:
------------------------------
1 - Date Tickets Parts
2 - 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
3 - Total 204 350
------------------------------
The first column of numbers is identifying the section they are in.
1 = Page Header
2 = Date Header
3 = Report Footer

All other sections are hidden (Ticket Header, Detail, Date Footer)

This is what I should be getting (Notice the Tickets column values):
------------------------------
Date Tickets Parts
3/2/09 74 116
3/3/09 27 41
3/4/09 28 61
3/5/09 41 50
3/6/09 34 82
Total 204 350

 

[Clif McIrvin]

On line 2 what is the controlsource for Tickets? (Date Header)

 

[TraciAnn]

=Count([TicketID])
--
TraciAnn

On line 2 what is the controlsource for Tickets? (Date Header)

 

[Clif McIrvin]

Thanks ...

change it to

=[name of running sum over group textbox on Tickets Header]

*and* move it (and the other Date Header controls) to the Date Footer.

--
Clif

=Count([TicketID])

 

[Clif McIrvin]

TraciAnn - I pulled up the test report I made yesterday and tried using
the group header section instead of the footer ... the group header line
*always* printed a value of 1, while the footer line shows the correct
value.

I suspect that your group header textbox for Tickets still has the wrong
control source - it needs to point to a running sum in the Tickets
Group, not ; also you will probably need to move those controls from the
group header to the group footer.

It's a matter of timing ... when formatting the group header no counting
for that group has been done yet.

 

[TraciAnn]

(Angelic Chorus in HD Surround Sound) Hallelujah...Hallelujah!!!!

All I needed to do was move everything to the Date Footer. And all my
numbers were there. That is EXACTLY what I needed.

Thank you SO MUCH Clif!!! And everyone else that helped!

Clif...Between you and me...we've got to get my Posts back down in the
single digits