calculating values in forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have calculated a value in a form. However, this value is the same for all
26 reports. It should not be. How do I set up the equation to calculate
each report in the form?
 
I meant record. What I did was in the datasheet view of the form, I went in
and created an expression to add 2 values together. These values are dates,
as I need the total number of days from 2 values. When I did this however,
it add all of the days from each record and gives me the total of them all.
I need the value for each record, not the grand total.

I didn't use a query.
 
Not really sure what you mean by continuous. Am pretty new to access and
trying to get my head around it. what i've done is created a table and then
a form from that table. In the form, I've needed to calculate the number of
days between 2 dates. This is the equation I've used: =Sum([Letter
Date]-[Audit Date])

These dates could be different in each record, and I need the sum of the
days on each record. What it's doing is adding all of the number of days
together and putting that total on each record. So, right now, each one of
my records says over 800 days. Is there a way to calculate this for just
each record?
 
Where do you have the sum? In the page footer, report footer, a grouped
footer?
--
Steph


wingnut said:
Not really sure what you mean by continuous. Am pretty new to access and
trying to get my head around it. what i've done is created a table and then
a form from that table. In the form, I've needed to calculate the number of
days between 2 dates. This is the equation I've used: =Sum([Letter
Date]-[Audit Date])

These dates could be different in each record, and I need the sum of the
days on each record. What it's doing is adding all of the number of days
together and putting that total on each record. So, right now, each one of
my records says over 800 days. Is there a way to calculate this for just
each record?

Klatuu said:
Describe the form, datasheet, continuous, ?
Click to expand...
Click to expand...
 
Sorry -- grouped footer is only on reports
--
Steph


StephWhitley said:
Where do you have the sum? In the page footer, report footer, a grouped
footer?
--
Steph


wingnut said:
Not really sure what you mean by continuous. Am pretty new to access and
trying to get my head around it. what i've done is created a table and then
a form from that table. In the form, I've needed to calculate the number of
days between 2 dates. This is the equation I've used: =Sum([Letter
Date]-[Audit Date])

These dates could be different in each record, and I need the sum of the
days on each record. What it's doing is adding all of the number of days
together and putting that total on each record. So, right now, each one of
my records says over 800 days. Is there a way to calculate this for just
each record?

Klatuu said:
Describe the form, datasheet, continuous, ?

:

I have calculated a value in a form. However, this value is the same for all
26 reports. It should not be. How do I set up the equation to calculate
each report in the form?
Click to expand...
Click to expand...
Click to expand...
 
I had it in the form footer. However, I have now just put it in the record
as it doesn't show up when you print it. I need it to be seen by others and
for each record to calculate separately.

Thanks!

StephWhitley said:
Sorry -- grouped footer is only on reports
--
Steph


StephWhitley said:
Where do you have the sum? In the page footer, report footer, a grouped
footer?
--
Steph


wingnut said:
Not really sure what you mean by continuous. Am pretty new to access and
trying to get my head around it. what i've done is created a table and then
a form from that table. In the form, I've needed to calculate the number of
days between 2 dates. This is the equation I've used: =Sum([Letter
Date]-[Audit Date])

These dates could be different in each record, and I need the sum of the
days on each record. What it's doing is adding all of the number of days
together and putting that total on each record. So, right now, each one of
my records says over 800 days. Is there a way to calculate this for just
each record?

:

Describe the form, datasheet, continuous, ?

:

I have calculated a value in a form. However, this value is the same for all
26 reports. It should not be. How do I set up the equation to calculate
each report in the form?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top