Calculated field in a report

  • Thread starter Thread starter KimberlyC
  • Start date Start date
K

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
 
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
 
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,

Fons Ponsioen said:
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


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

--
Duane Hookom
MS Access MVP


KimberlyC said:
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,

Fons Ponsioen said:
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


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

Thanks!

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

--
Duane Hookom
MS Access MVP


KimberlyC said:
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,

Fons Ponsioen said:
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


.
Click to expand...
Click to expand...
Click to expand...
 
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!
Duane Hookom said:
What is the value in your Over45 field? You should be able to use:
=Sum( Abs([Over45]=...YourValue...) )

--
Duane Hookom
MS Access MVP


KimberlyC said:
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,

Fons Ponsioen said:
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


.
Click to expand...
Click to expand...
Click to expand...
 
=Sum( Abs([Over45]="*") )

--
Duane Hookom
MS Access MVP


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

Thanks!

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

--
Duane Hookom
MS Access MVP


KimberlyC said:
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
Click to expand...
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


.
Click to expand...
Click to expand...
Click to expand...
 
Hi
That worked!! Thanks!!

Duane Hookom said:
=Sum( Abs([Over45]="*") )

--
Duane Hookom
MS Access MVP


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

Thanks!

Duane Hookom said:
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
Click to expand...
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


.
Click to expand...
Click to expand...
Click to expand...
 
try this:

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

:)

KimberlyC said:
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!
Duane Hookom said:
What is the value in your Over45 field? You should be able to use:
=Sum( Abs([Over45]=...YourValue...) )

--
Duane Hookom
MS Access MVP


KimberlyC said:
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
Click to expand...
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


.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top