Counts & Colours

[FrunkaBlunka]

Hi,

I am trying to create a report which shows successful and unsuccessful
tenders for the month. The table I am creating the report from has the
following fields:

Quote ID (number)
Project Name (text)
Value (number)
Client (text)
Won (yes/no)

1. I need the report to count the number of quotes I submit for the
month and also count the number of those that are successful by
verifying the Won check box. I need my footer to look something like
this:

Quotes submitted: 42
Successful: 18
Win Ratio: 43%

2. I also need to identify successful quotes on the report with a
different colour.

Should i be looking to do a query for the count and conditional
formatting with an expression for the different colour?
Any help would be appreciated. Thanks

 

[Duane Hookom]

To count the number of records in a report section, use a text box with a
control source of:
=Count(*)
To count the number of records in a report section where an expression is
true, use a text box with a control source like:
=Sum(Abs([Your True/False Expression]))
In your case, try:
=Sum(Abs([Won]))
You can set a control source to divide one value by another:
=Sum(Abs([Won]))/Count(*)

Try use Conditional Formatting for the colors.

 

[FrunkaBlunka]

To count the number of records in a report section, use a text box with a
control source of:
=Count(*)
To count the number of records in a report section where an expression is
true, use a text box with a control source like:
=Sum(Abs([Your True/False Expression]))
In your case, try:
=Sum(Abs([Won]))
You can set a control source to divide one value by another:
=Sum(Abs([Won]))/Count(*)

Try use Conditional Formatting for the colors.

--
Duane Hookom
Microsoft Access MVP

Hi,

I am trying to create a report which shows successful and unsuccessful
tenders for the month. The table I am creating the report from has the
following fields:

Quote ID (number)
Project Name (text)
Value (number)
Client (text)
Won (yes/no)

1. I need the report to count the number of quotes I submit for the
month and also count the number of those that are successful by
verifying the Won check box. I need my footer to look something like
this:

Quotes submitted: 42
Successful: 18
Win Ratio: 43%

2. I also need to identify successful quotes on the report with a
different colour.

Should i be looking to do a query for the count and conditional
formatting with an expression for the different colour?
Any help would be appreciated. Thanks

Works perfectly.
Thanks for your help.

 

[FrunkaBlunka]

To count the number of records in a report section, use a text box with a
control source of:
=Count(*)
To count the number of records in a report section where an expression is
true, use a text box with a control source like:
=Sum(Abs([Your True/False Expression]))
In your case, try:
=Sum(Abs([Won]))
You can set a control source to divide one value by another:
=Sum(Abs([Won]))/Count(*)

Try use Conditional Formatting for the colors.

--
Duane Hookom
Microsoft Access MVP

Hi,

I am trying to create a report which shows successful and unsuccessful
tenders for the month. The table I am creating the report from has the
following fields:

Quote ID (number)
Project Name (text)
Value (number)
Client (text)
Won (yes/no)

1. I need the report to count the number of quotes I submit for the
month and also count the number of those that are successful by
verifying the Won check box. I need my footer to look something like
this:

Quotes submitted: 42
Successful: 18
Win Ratio: 43%

2. I also need to identify successful quotes on the report with a
different colour.

Should i be looking to do a query for the count and conditional
formatting with an expression for the different colour?
Any help would be appreciated. Thanks

One more question:

How do i add the values (Value) of the checked only (Won)?

Report Footer:
Quotes submitted: 42
Successful: 18
Win Ratio: 43%

Total of submitted quotes: $262,00
Total of successful quotes: $94,200

Thanks again for your help.

 

[Duane Hookom]

=Sum(Abs([Won]) * [Value])
--
Duane Hookom
Microsoft Access MVP

To count the number of records in a report section, use a text box with a
control source of:
=Count(*)
To count the number of records in a report section where an expression is
true, use a text box with a control source like:
=Sum(Abs([Your True/False Expression]))
In your case, try:
=Sum(Abs([Won]))
You can set a control source to divide one value by another:
=Sum(Abs([Won]))/Count(*)

Try use Conditional Formatting for the colors.

--
Duane Hookom
Microsoft Access MVP

Hi,

I am trying to create a report which shows successful and unsuccessful
tenders for the month. The table I am creating the report from has the
following fields:

Quote ID (number)
Project Name (text)
Value (number)
Client (text)
Won (yes/no)

1. I need the report to count the number of quotes I submit for the
month and also count the number of those that are successful by
verifying the Won check box. I need my footer to look something like
this:

Quotes submitted: 42
Successful: 18
Win Ratio: 43%

2. I also need to identify successful quotes on the report with a
different colour.

Should i be looking to do a query for the count and conditional
formatting with an expression for the different colour?
Any help would be appreciated. Thanks

One more question:

How do i add the values (Value) of the checked only (Won)?

Report Footer:
Quotes submitted: 42
Successful: 18
Win Ratio: 43%

Total of submitted quotes: $262,00
Total of successful quotes: $94,200

Thanks again for your help.

 

[FrunkaBlunka]

=Sum(Abs([Won]) * [Value])
--
Duane Hookom
Microsoft Access MVP

To count the number of records in a report section, use a text box with a
control source of:
=Count(*)
To count the number of records in a report section where an expression is
true, use a text box with a control source like:
=Sum(Abs([Your True/False Expression]))
In your case, try:
=Sum(Abs([Won]))
You can set a control source to divide one value by another:
=Sum(Abs([Won]))/Count(*)
Try use Conditional Formatting for the colors.
--
Duane Hookom
Microsoft Access MVP
:
Hi,
I am trying to create a report which shows successful and unsuccessful
tenders for the month. The table I am creating the report from has the
following fields:
Quote ID (number)
Project Name (text)
Value (number)
Client (text)
Won (yes/no)
1. I need the report to count the number of quotes I submit for the
month and also count the number of those that are successful by
verifying the Won check box. I need my footer to look something like
this:
Quotes submitted: 42
Successful: 18
Win Ratio: 43%
2. I also need to identify successful quotes on the report with a
different colour.
Should i be looking to do a query for the count and conditional
formatting with an expression for the different colour?
Any help would be appreciated. Thanks

One more question:

How do i add the values (Value) of the checked only (Won)?

Report Footer:
Quotes submitted: 42
Successful: 18
Win Ratio: 43%

Total of submitted quotes: $262,00
Total of successful quotes: $94,200

Thanks again for your help.

Thanks Duane