Count Combo Box Occurences on a date

[Rod]

Hello,

How can I ceate a report that will count the instances of valid choices for
a text combo box [CALL_RESULT] on a particular date then total the choices,
e.g.:

Date cbchoice1 cbchoice2 cbchoice3 cbchoice4
total
Jan 22, 2007 10 2 7 3
22
Jan 23, 2007 8 8 3
0 19

Thanks much!

 

[Duane Hookom]

Start by creating a crosstab query with Date as the Row Heading, Call_Result
as the Column Heading and Count primary key field as the Value.

 

[Rod]

OK, this looks promising. So, how do I have it give me the count of
instances when cbchoice = "Yes"?

Start by creating a crosstab query with Date as the Row Heading, Call_Result
as the Column Heading and Count primary key field as the Value.

--
Duane Hookom
Microsoft Access MVP

Hello,

How can I ceate a report that will count the instances of valid choices for
a text combo box [CALL_RESULT] on a particular date then total the choices,
e.g.:

Date cbchoice1 cbchoice2 cbchoice3 cbchoice4
total
Jan 22, 2007 10 2 7 3
22
Jan 23, 2007 8 8 3
0 19

Thanks much!

 

[Rod]

Disregard the previous. I think you got it!

Thanks!

Start by creating a crosstab query with Date as the Row Heading, Call_Result
as the Column Heading and Count primary key field as the Value.

--
Duane Hookom
Microsoft Access MVP

Hello,

How can I ceate a report that will count the instances of valid choices for
a text combo box [CALL_RESULT] on a particular date then total the choices,
e.g.:

Date cbchoice1 cbchoice2 cbchoice3 cbchoice4
total
Jan 22, 2007 10 2 7 3
22
Jan 23, 2007 8 8 3
0 19

Thanks much!

 

[Rod]

After closer review, the query is not returing the data I expected. For
example, on 1/24/07 33 messages were left and 6 appointments were made, i.e.
[CALLED_ON]=1/24/07 33 times where [CALL_RESULT]="Message".
[CALL_RESULT]="Appointment" 6 times on that day ([CALLED_ON] is of type
date). FYI: [CALL_RESULT] is the same as cbchoice in the original example;
using "cbchoice" was my attempt at simplifying the problem which may have
done the opposite - appologies. I am getting different numbers from the
query than what actually took place.
[CALL_RESULTS] = "Message" should be 33 but the query is returning 1
[CALL_RESULTS] = "Appointment" should be 6 but the query is returning 2

The good news is the query does have the proper headings and [CALLED_ON] is
the correct date list.

Start by creating a crosstab query with Date as the Row Heading, Call_Result
as the Column Heading and Count primary key field as the Value.

--
Duane Hookom
Microsoft Access MVP

Hello,

How can I ceate a report that will count the instances of valid choices for
a text combo box [CALL_RESULT] on a particular date then total the choices,
e.g.:

Date cbchoice1 cbchoice2 cbchoice3 cbchoice4
total
Jan 22, 2007 10 2 7 3
22
Jan 23, 2007 8 8 3
0 19

Thanks much!

 

[Rod]

Found the answer. The resulting number of 33 messages and 6 appointments was
the result of someone calling back from 1/23/07. So how can I have the query
or report look at [RETURNED_CALL] and add the results, i.e.:

Give me the count of the "Messages from [CALLED_ON].
Give me the count of "Appointments" regardless of [CALLED_ON] BUT the
appointment was made today which is stored in [Booked]

Thanks

Start by creating a crosstab query with Date as the Row Heading, Call_Result
as the Column Heading and Count primary key field as the Value.

--
Duane Hookom
Microsoft Access MVP

Hello,

How can I ceate a report that will count the instances of valid choices for
a text combo box [CALL_RESULT] on a particular date then total the choices,
e.g.:

Date cbchoice1 cbchoice2 cbchoice3 cbchoice4
total
Jan 22, 2007 10 2 7 3
22
Jan 23, 2007 8 8 3
0 19

Thanks much!

 

[Duane Hookom]

I am confused regarding your table structure. I don't know what you mean by
"Messages from [Called_ON]" etc.

--
Duane Hookom
Microsoft Access MVP

Found the answer. The resulting number of 33 messages and 6 appointments was
the result of someone calling back from 1/23/07. So how can I have the query
or report look at [RETURNED_CALL] and add the results, i.e.:

Give me the count of the "Messages from [CALLED_ON].
Give me the count of "Appointments" regardless of [CALLED_ON] BUT the
appointment was made today which is stored in [Booked]

Thanks

Start by creating a crosstab query with Date as the Row Heading, Call_Result
as the Column Heading and Count primary key field as the Value.

--
Duane Hookom
Microsoft Access MVP

Hello,

How can I ceate a report that will count the instances of valid choices for
a text combo box [CALL_RESULT] on a particular date then total the choices,
e.g.:

Date cbchoice1 cbchoice2 cbchoice3 cbchoice4
total
Jan 22, 2007 10 2 7 3
22
Jan 23, 2007 8 8 3
0 19

Thanks much!

 

[Rod]

[CALLED_ON] is the date the call was placed. "Message" is a combo choice
available in [CALL_RESULT]. So, I could have [CALLED_ON] = 1/24/07 and
[CALL_RESULT] = "Message". So, the stats I am trying to get are of the
nature: how many calls were made each date and what was the result/breakdown
of the calls.

Thanks!

I am confused regarding your table structure. I don't know what you mean by
"Messages from [Called_ON]" etc.

--
Duane Hookom
Microsoft Access MVP

Found the answer. The resulting number of 33 messages and 6 appointments was
the result of someone calling back from 1/23/07. So how can I have the query
or report look at [RETURNED_CALL] and add the results, i.e.:

Give me the count of the "Messages from [CALLED_ON].
Give me the count of "Appointments" regardless of [CALLED_ON] BUT the
appointment was made today which is stored in [Booked]

Thanks

Start by creating a crosstab query with Date as the Row Heading, Call_Result
as the Column Heading and Count primary key field as the Value.

--
Duane Hookom
Microsoft Access MVP


:

Hello,

How can I ceate a report that will count the instances of valid choices for
a text combo box [CALL_RESULT] on a particular date then total the choices,
e.g.:

Date cbchoice1 cbchoice2 cbchoice3 cbchoice4
total
Jan 22, 2007 10 2 7 3
22
Jan 23, 2007 8 8 3
0 19

Thanks much!

 

[Duane Hookom]

What do you want to do with Returned Call and Booked? Are these also fields?
How do you want them incorporated into your solution?

--
Duane Hookom
Microsoft Access MVP

[CALLED_ON] is the date the call was placed. "Message" is a combo choice
available in [CALL_RESULT]. So, I could have [CALLED_ON] = 1/24/07 and
[CALL_RESULT] = "Message". So, the stats I am trying to get are of the
nature: how many calls were made each date and what was the result/breakdown
of the calls.

Thanks!

I am confused regarding your table structure. I don't know what you mean by
"Messages from [Called_ON]" etc.

--
Duane Hookom
Microsoft Access MVP

Found the answer. The resulting number of 33 messages and 6 appointments was
the result of someone calling back from 1/23/07. So how can I have the query
or report look at [RETURNED_CALL] and add the results, i.e.:

Give me the count of the "Messages from [CALLED_ON].
Give me the count of "Appointments" regardless of [CALLED_ON] BUT the
appointment was made today which is stored in [Booked]

Thanks

:

Start by creating a crosstab query with Date as the Row Heading, Call_Result
as the Column Heading and Count primary key field as the Value.

--
Duane Hookom
Microsoft Access MVP


:

Hello,

How can I ceate a report that will count the instances of valid choices for
a text combo box [CALL_RESULT] on a particular date then total the choices,
e.g.:

Date cbchoice1 cbchoice2 cbchoice3 cbchoice4
total
Jan 22, 2007 10 2 7 3
22
Jan 23, 2007 8 8 3
0 19

Thanks much!

 

[Rod]

The goal is the report should like look this:
Called On Appointment Messages
Wed, Jan 24 07 7 33

This much I am getting. The general idea is a report that will show how
many messages were made that day and how many appointments were made that
day. However, someone cold have returned a call from Monday, Jan 22 07 BUT
the appointment was made on Wed, Jan 24 07, so [CALL_Result] = "Message" for
date Mon, Jan 22 07 and [Booked] = Wed, Jan 24 07. So, if 1 call was made on
Mon and the appointment was booked on Wed due to a call back the report
should look like:

Called On Appointment Messages
Wed, Jan 24 07 1 0
Mon, Jan 22 07 0 1

Note:
[CALLED_ON] = date call was made
[Booked] = date appointment was made. This is only used if an appointment
is made
[CALL_RESULT] = what was the result of the call
Thanks much!

What do you want to do with Returned Call and Booked? Are these also fields?
How do you want them incorporated into your solution?

--
Duane Hookom
Microsoft Access MVP

[CALLED_ON] is the date the call was placed. "Message" is a combo choice
available in [CALL_RESULT]. So, I could have [CALLED_ON] = 1/24/07 and
[CALL_RESULT] = "Message". So, the stats I am trying to get are of the
nature: how many calls were made each date and what was the result/breakdown
of the calls.

Thanks!

I am confused regarding your table structure. I don't know what you mean by
"Messages from [Called_ON]" etc.

--
Duane Hookom
Microsoft Access MVP


:

Found the answer. The resulting number of 33 messages and 6 appointments was
the result of someone calling back from 1/23/07. So how can I have the query
or report look at [RETURNED_CALL] and add the results, i.e.:

Give me the count of the "Messages from [CALLED_ON].
Give me the count of "Appointments" regardless of [CALLED_ON] BUT the
appointment was made today which is stored in [Booked]

Thanks

:

Start by creating a crosstab query with Date as the Row Heading, Call_Result
as the Column Heading and Count primary key field as the Value.

--
Duane Hookom
Microsoft Access MVP


:

Hello,

How can I ceate a report that will count the instances of valid choices for
a text combo box [CALL_RESULT] on a particular date then total the choices,
e.g.:

Date cbchoice1 cbchoice2 cbchoice3 cbchoice4
total
Jan 22, 2007 10 2 7 3
22
Jan 23, 2007 8 8 3
0 19

Thanks much!

 

[Duane Hookom]

If you want to count one record twice (or more) since you have two date
fields, you may need to use a union query and then base your crosstab on the
the union query. If you can't figure this out, please come back with about
5-8 actual records and then how you would want these records displayed in
your report.

--
Duane Hookom
Microsoft Access MVP

The goal is the report should like look this:
Called On Appointment Messages
Wed, Jan 24 07 7 33

This much I am getting. The general idea is a report that will show how
many messages were made that day and how many appointments were made that
day. However, someone cold have returned a call from Monday, Jan 22 07 BUT
the appointment was made on Wed, Jan 24 07, so [CALL_Result] = "Message" for
date Mon, Jan 22 07 and [Booked] = Wed, Jan 24 07. So, if 1 call was made on
Mon and the appointment was booked on Wed due to a call back the report
should look like:

Called On Appointment Messages
Wed, Jan 24 07 1 0
Mon, Jan 22 07 0 1

Note:
[CALLED_ON] = date call was made
[Booked] = date appointment was made. This is only used if an appointment
is made
[CALL_RESULT] = what was the result of the call
Thanks much!

What do you want to do with Returned Call and Booked? Are these also fields?
How do you want them incorporated into your solution?

--
Duane Hookom
Microsoft Access MVP

[CALLED_ON] is the date the call was placed. "Message" is a combo choice
available in [CALL_RESULT]. So, I could have [CALLED_ON] = 1/24/07 and
[CALL_RESULT] = "Message". So, the stats I am trying to get are of the
nature: how many calls were made each date and what was the result/breakdown
of the calls.

Thanks!

:

I am confused regarding your table structure. I don't know what you mean by
"Messages from [Called_ON]" etc.

--
Duane Hookom
Microsoft Access MVP


:

Found the answer. The resulting number of 33 messages and 6 appointments was
the result of someone calling back from 1/23/07. So how can I have the query
or report look at [RETURNED_CALL] and add the results, i.e.:

Give me the count of the "Messages from [CALLED_ON].
Give me the count of "Appointments" regardless of [CALLED_ON] BUT the
appointment was made today which is stored in [Booked]

Thanks

:

Start by creating a crosstab query with Date as the Row Heading, Call_Result
as the Column Heading and Count primary key field as the Value.

--
Duane Hookom
Microsoft Access MVP


:

Hello,

How can I ceate a report that will count the instances of valid choices for
a text combo box [CALL_RESULT] on a particular date then total the choices,
e.g.:

Date cbchoice1 cbchoice2 cbchoice3 cbchoice4
total
Jan 22, 2007 10 2 7 3
22
Jan 23, 2007 8 8 3
0 19

Thanks much!