Calculated field in a report

[KimberlyC]

Hi

I have a report that is based on a query . The query has a calculated field
in it that displays the number of days an order has been out.
The report is grouped by Rep and shows a list of their orders and the
number of days ("Days") each order has been out .

I am now trying to create a calculated field in the Rep Footer to shows how
many orders are greater than or equal to 45 days..This calcuation would look
at the "days" field and count how many are >=45 days, and then show the
total .

Any help with this would be greatly appreciated.

Thanks in advance,
Kimberly

 

[Fons Ponsioen]

The way I would approach this is:
In the underlying query create a variable "45+" set it to
1 or 0 depending on the value of Days.
In the report footer sum([45+])
Hope this helsp.
Fons

 

[KimberlyC]

Thanks for the help...
I've now made it were the report shows a * next to the orders that are over
45 days. The field name is Over45.
Is there a calculation that will count the records that have * next to it
only?
I've tried =count([over45)] and that counts all the records ...even the ones
that do not have an * next to it.

Thanks,

The way I would approach this is:
In the underlying query create a variable "45+" set it to
1 or 0 depending on the value of Days.
In the report footer sum([45+])
Hope this helsp.
Fons

-----Original Message-----
Hi

I have a report that is based on a query . The query has a calculated field
in it that displays the number of days an order has been out.
The report is grouped by Rep and shows a list of their orders and the
number of days ("Days") each order has been out .

I am now trying to create a calculated field in the Rep Footer to shows how
many orders are greater than or equal to 45 days..This calcuation would look
at the "days" field and count how many are >=45 days, and then show the
total .

Any help with this would be greatly appreciated.

Thanks in advance,
Kimberly


.

 

[Duane Hookom]

What is the value in your Over45 field? You should be able to use:
=Sum( Abs([Over45]=...YourValue...) )

--
Duane Hookom
MS Access MVP

Thanks for the help...
I've now made it were the report shows a * next to the orders that are over
45 days. The field name is Over45.
Is there a calculation that will count the records that have * next to it
only?
I've tried =count([over45)] and that counts all the records ...even the ones
that do not have an * next to it.

Thanks,

The way I would approach this is:
In the underlying query create a variable "45+" set it to
1 or 0 depending on the value of Days.
In the report footer sum([45+])
Hope this helsp.
Fons

-----Original Message-----
Hi

I have a report that is based on a query . The query has a calculated field
in it that displays the number of days an order has been out.
The report is grouped by Rep and shows a list of their orders and the
number of days ("Days") each order has been out .

I am now trying to create a calculated field in the Rep Footer to shows how
many orders are greater than or equal to 45 days..This calcuation would look
at the "days" field and count how many are >=45 days, and then show the
total .

Any help with this would be greatly appreciated.

Thanks in advance,
Kimberly


.

 

[KimberlyC]

It's an (*) in the Over45 field.

Thanks!

What is the value in your Over45 field? You should be able to use:
=Sum( Abs([Over45]=...YourValue...) )

--
Duane Hookom
MS Access MVP

Thanks for the help...
I've now made it were the report shows a * next to the orders that are over
45 days. The field name is Over45.
Is there a calculation that will count the records that have * next to it
only?
I've tried =count([over45)] and that counts all the records ...even the ones
that do not have an * next to it.

Thanks,

The way I would approach this is:
In the underlying query create a variable "45+" set it to
1 or 0 depending on the value of Days.
In the report footer sum([45+])
Hope this helsp.
Fons
-----Original Message-----
Hi

I have a report that is based on a query . The query has
a calculated field
in it that displays the number of days an order has been
out.
The report is grouped by Rep and shows a list of their
orders and the
number of days ("Days") each order has been out .

I am now trying to create a calculated field in the Rep
Footer to shows how
many orders are greater than or equal to 45 days..This
calcuation would look
at the "days" field and count how many are >=45 days,
and then show the
total .

Any help with this would be greatly appreciated.

Thanks in advance,
Kimberly


.

 

[KimberlyC]

Basically I only want the calculated field to count the number of records
that are over 45 days. The days field shows the number of days the record
has been out and I really do not need the over45 days field. I'm just
looking for a way to count on the records that are over 45 days old (by
looking a the days field).
Maybe that's easier???
I don't know what calculation to use for that.

Thanks!

What is the value in your Over45 field? You should be able to use:
=Sum( Abs([Over45]=...YourValue...) )

--
Duane Hookom
MS Access MVP

Thanks for the help...
I've now made it were the report shows a * next to the orders that are over
45 days. The field name is Over45.
Is there a calculation that will count the records that have * next to it
only?
I've tried =count([over45)] and that counts all the records ...even the ones
that do not have an * next to it.

Thanks,

The way I would approach this is:
In the underlying query create a variable "45+" set it to
1 or 0 depending on the value of Days.
In the report footer sum([45+])
Hope this helsp.
Fons
-----Original Message-----
Hi

I have a report that is based on a query . The query has
a calculated field
in it that displays the number of days an order has been
out.
The report is grouped by Rep and shows a list of their
orders and the
number of days ("Days") each order has been out .

I am now trying to create a calculated field in the Rep
Footer to shows how
many orders are greater than or equal to 45 days..This
calcuation would look
at the "days" field and count how many are >=45 days,
and then show the
total .

Any help with this would be greatly appreciated.

Thanks in advance,
Kimberly


.

 

[Duane Hookom]

=Sum( Abs([Over45]="*") )

--
Duane Hookom
MS Access MVP

It's an (*) in the Over45 field.

Thanks!

What is the value in your Over45 field? You should be able to use:
=Sum( Abs([Over45]=...YourValue...) )

--
Duane Hookom
MS Access MVP

Thanks for the help...
I've now made it were the report shows a * next to the orders that are over
45 days. The field name is Over45.
Is there a calculation that will count the records that have * next to it
only?
I've tried =count([over45)] and that counts all the records ...even

the
ones

that do not have an * next to it.

Thanks,

The way I would approach this is:
In the underlying query create a variable "45+" set it to
1 or 0 depending on the value of Days.
In the report footer sum([45+])
Hope this helsp.
Fons
-----Original Message-----
Hi

I have a report that is based on a query . The query has
a calculated field
in it that displays the number of days an order has been
out.
The report is grouped by Rep and shows a list of their
orders and the
number of days ("Days") each order has been out .

I am now trying to create a calculated field in the Rep
Footer to shows how
many orders are greater than or equal to 45 days..This
calcuation would look
at the "days" field and count how many are >=45 days,
and then show the
total .

Any help with this would be greatly appreciated.

Thanks in advance,
Kimberly


.

 

[KimberlyC]

Hi
That worked!! Thanks!!

=Sum( Abs([Over45]="*") )

--
Duane Hookom
MS Access MVP

It's an (*) in the Over45 field.

Thanks!

What is the value in your Over45 field? You should be able to use:
=Sum( Abs([Over45]=...YourValue...) )

--
Duane Hookom
MS Access MVP


Thanks for the help...
I've now made it were the report shows a * next to the orders that are
over
45 days. The field name is Over45.
Is there a calculation that will count the records that have * next

to
it

only?
I've tried =count([over45)] and that counts all the records ...even the
ones
that do not have an * next to it.

Thanks,

The way I would approach this is:
In the underlying query create a variable "45+" set it to
1 or 0 depending on the value of Days.
In the report footer sum([45+])
Hope this helsp.
Fons
-----Original Message-----
Hi

I have a report that is based on a query . The query has
a calculated field
in it that displays the number of days an order has been
out.
The report is grouped by Rep and shows a list of their
orders and the
number of days ("Days") each order has been out .

I am now trying to create a calculated field in the Rep
Footer to shows how
many orders are greater than or equal to 45 days..This
calcuation would look
at the "days" field and count how many are >=45 days,
and then show the
total .

Any help with this would be greatly appreciated.

Thanks in advance,
Kimberly


.

 

[Bill Crawford]

try this:

=sum(iif([over45]>= 45,1,0)

Basically I only want the calculated field to count the number of records
that are over 45 days. The days field shows the number of days the record
has been out and I really do not need the over45 days field. I'm just
looking for a way to count on the records that are over 45 days old (by
looking a the days field).
Maybe that's easier???
I don't know what calculation to use for that.

Thanks!

What is the value in your Over45 field? You should be able to use:
=Sum( Abs([Over45]=...YourValue...) )

--
Duane Hookom
MS Access MVP

Thanks for the help...
I've now made it were the report shows a * next to the orders that are over
45 days. The field name is Over45.
Is there a calculation that will count the records that have * next to it
only?
I've tried =count([over45)] and that counts all the records ...even

the
ones

that do not have an * next to it.

Thanks,

The way I would approach this is:
In the underlying query create a variable "45+" set it to
1 or 0 depending on the value of Days.
In the report footer sum([45+])
Hope this helsp.
Fons
-----Original Message-----
Hi

I have a report that is based on a query . The query has
a calculated field
in it that displays the number of days an order has been
out.
The report is grouped by Rep and shows a list of their
orders and the
number of days ("Days") each order has been out .

I am now trying to create a calculated field in the Rep
Footer to shows how
many orders are greater than or equal to 45 days..This
calcuation would look
at the "days" field and count how many are >=45 days,
and then show the
total .

Any help with this would be greatly appreciated.

Thanks in advance,
Kimberly


.