Reports

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I am trying to set up a report in Access 2000 that will
show individual entries in a specific field and at the
bottom of the report display the total of all values in
that field. The field has been set up as numeric.
 
Where are you having an issue? You can add a text box to the Report Footer
section and set the Control Source property to
=Sum([YourNumericField])
 
I tried that. When I do it with asmple data it doesn't
add to the right number. Do I have to set any other
field in the property box?
-----Original Message-----
Where are you having an issue? You can add a text box to the Report Footer
section and set the Control Source property to
=Sum([YourNumericField])

--
Duane Hookom
MS Access MVP


Gary said:
I am trying to set up a report in Access 2000 that will
show individual entries in a specific field and at the
bottom of the report display the total of all values in
that field. The field has been set up as numeric.
Click to expand...


.
Click to expand...
 
What do you mean by "doesn't add to the right number"? The method I
suggested works. Did you create the text box in the report footer? What
expression did you use? What value are you getting that isn't right?

--
Duane Hookom
MS Access MVP


I tried that. When I do it with asmple data it doesn't
add to the right number. Do I have to set any other
field in the property box?
-----Original Message-----
Where are you having an issue? You can add a text box to the Report Footer
section and set the Control Source property to
=Sum([YourNumericField])

--
Duane Hookom
MS Access MVP


Gary said:
I am trying to set up a report in Access 2000 that will
show individual entries in a specific field and at the
bottom of the report display the total of all values in
that field. The field has been set up as numeric.
Click to expand...


.
Click to expand...
Click to expand...
 
Ok I'll give you a step by step run down of what I did.
I have a database with the field name of Roast Turkey 15
lb. I have created a report that has that field in it.
That field has the data type of number. I have entered 2
sample records into the database When I run the report I
successfully display the data for each record. I then
switch to design view and add a text box in the footer
area. It automatically says unbounded in the box. After
single clicking in the box it turns white for input and I
click on the properties button. A text box form opens
and I click on the data tab. I click in the Control
Source box and type the following:"=sum([Roast Turkey
15lb])" I leave input mask blank. I have tried setting
Running Sum in its default value of No, Over Group, Over
all and I get the same result. In the footer I
see "#Error" I am using Acces 2000. If you are willing
I will email the entire file to you so that you can see
what I did and show me what I did wrong.

Thanks for your help.

-----Original Message-----
What do you mean by "doesn't add to the right number"? The method I
suggested works. Did you create the text box in the report footer? What
expression did you use? What value are you getting that isn't right?

--
Duane Hookom
MS Access MVP


I tried that. When I do it with asmple data it doesn't
add to the right number. Do I have to set any other
field in the property box?
-----Original Message-----
Where are you having an issue? You can add a text box
Click to expand...
to
the Report Footer
section and set the Control Source property to
=Sum([YourNumericField])

--
Duane Hookom
MS Access MVP


I am trying to set up a report in Access 2000 that will
show individual entries in a specific field and at the
bottom of the report display the total of all values in
that field. The field has been set up as numeric.


.
Click to expand...
Click to expand...


.
Click to expand...
 
In each reply that I have sent, I have asked you to confirm the text box is
in the Report footer and you haven't provided any feedback regarding this.
Make sure your text box is in the Report footer and not the Page footer.

--
Duane Hookom
Microsoft Access MVP


gary said:
Ok I'll give you a step by step run down of what I did.
I have a database with the field name of Roast Turkey 15
lb. I have created a report that has that field in it.
That field has the data type of number. I have entered 2
sample records into the database When I run the report I
successfully display the data for each record. I then
switch to design view and add a text box in the footer
area. It automatically says unbounded in the box. After
single clicking in the box it turns white for input and I
click on the properties button. A text box form opens
and I click on the data tab. I click in the Control
Source box and type the following:"=sum([Roast Turkey
15lb])" I leave input mask blank. I have tried setting
Running Sum in its default value of No, Over Group, Over
all and I get the same result. In the footer I
see "#Error" I am using Acces 2000. If you are willing
I will email the entire file to you so that you can see
what I did and show me what I did wrong.

Thanks for your help.

-----Original Message-----
What do you mean by "doesn't add to the right number"? The method I
suggested works. Did you create the text box in the report footer? What
expression did you use? What value are you getting that isn't right?

--
Duane Hookom
MS Access MVP


I tried that. When I do it with asmple data it doesn't
add to the right number. Do I have to set any other
field in the property box?

-----Original Message-----
Where are you having an issue? You can add a text box to
the Report Footer
section and set the Control Source property to
=Sum([YourNumericField])

--
Duane Hookom
MS Access MVP


I am trying to set up a report in Access 2000 that will
show individual entries in a specific field and at the
bottom of the report display the total of all values in
that field. The field has been set up as numeric.


.
Click to expand...


.
Click to expand...
Click to expand...
 
I am not sure. The best I can do is describe the
position on the page in design view. From the top of the
page down there are the following dividors each having
and arrow pointing below it:
Reoprt Header, Page Header, Detail, Page Footer, Report
Footer. The text box is between Page Footer and Report
Footer. There is no grid below the Report Footer bar.
Do I need to create space below this last bar and
recreate the text box there? If so how do I move the
bars up on the page?

-----Original Message-----
In each reply that I have sent, I have asked you to confirm the text box is
in the Report footer and you haven't provided any feedback regarding this.
Make sure your text box is in the Report footer and not the Page footer.

--
Duane Hookom
Microsoft Access MVP


gary said:
Ok I'll give you a step by step run down of what I did.
I have a database with the field name of Roast Turkey 15
lb. I have created a report that has that field in it.
That field has the data type of number. I have entered 2
sample records into the database When I run the report I
successfully display the data for each record. I then
switch to design view and add a text box in the footer
area. It automatically says unbounded in the box. After
single clicking in the box it turns white for input and I
click on the properties button. A text box form opens
and I click on the data tab. I click in the Control
Source box and type the following:"=sum([Roast Turkey
15lb])" I leave input mask blank. I have tried setting
Running Sum in its default value of No, Over Group, Over
all and I get the same result. In the footer I
see "#Error" I am using Acces 2000. If you are willing
I will email the entire file to you so that you can see
what I did and show me what I did wrong.

Thanks for your help.

-----Original Message-----
What do you mean by "doesn't add to the right number"? The method I
suggested works. Did you create the text box in the report footer? What
expression did you use? What value are you getting
Click to expand...
that
isn't right?
--
Duane Hookom
MS Access MVP


I tried that. When I do it with asmple data it doesn't
add to the right number. Do I have to set any other
field in the property box?

-----Original Message-----
Where are you having an issue? You can add a text
Click to expand...
box
to
the Report Footer
section and set the Control Source property to
=Sum([YourNumericField])

--
Duane Hookom
MS Access MVP


I am trying to set up a report in Access 2000
Click to expand...
that
will
show individual entries in a specific field and
Click to expand...
at
the
bottom of the report display the total of all values in
that field. The field has been set up as numeric.


.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Gary said:
I am not sure. The best I can do is describe the
position on the page in design view. From the top of the
page down there are the following dividors each having
and arrow pointing below it:
Reoprt Header, Page Header, Detail, Page Footer, Report
Footer. The text box is between Page Footer and Report
Footer. There is no grid below the Report Footer bar.
Do I need to create space below this last bar and
recreate the text box there?
Yes.

If so how do I move the bars up on the page?
Click to expand...

I don't understand this question. You cannot change the relative position of
the built in section dividers. You can place your mouse cursor at the existing
bottom edge and the pointer will change into a sizing pointer at which point you
can drag the mouse to make the section taller or shorter.
 
OK I got the text box into the report footer and was
asked to "Enter Parameter Value" I don't know what to
place here. If I leave it blank and hit OK the textbox
appears as 0 on the last line of the report.
 
Gary said:
OK I got the text box into the report footer and was
asked to "Enter Parameter Value" I don't know what to
place here. If I leave it blank and hit OK the textbox
appears as 0 on the last line of the report.
Click to expand...

When a Report or Query unexpectedly asks for a parameter it means you have made
a reference to a field or control that does not exist. Check your spelling.
Since you didn't indicate the name of the parameter you were asked for I can't
speculate any further, but as an example...

If I have a field named [InvoiceAmount] and I place a TextBox with
=Sum([InvoicAmount]) in the ReportFooter I will be prompted for a parameter
because I misspelled the name of the field in the expression.
 
Fixed that problem, I no longer get a prompt to enter a
parameter. The total is not right. I have 2 records in
the database. Record 1 has a value of 1 and record 2 has
a value of 2 in the same field. That should sum to 3 but
my report says 1.

What now?

-----Original Message-----
Gary said:
OK I got the text box into the report footer and was
asked to "Enter Parameter Value" I don't know what to
place here. If I leave it blank and hit OK the textbox
appears as 0 on the last line of the report.
Click to expand...

When a Report or Query unexpectedly asks for a parameter it means you have made
a reference to a field or control that does not exist. Check your spelling.
Since you didn't indicate the name of the parameter you were asked for I can't
speculate any further, but as an example...

If I have a field named [InvoiceAmount] and I place a TextBox with
=Sum([InvoicAmount]) in the ReportFooter I will be prompted for a parameter
because I misspelled the name of the field in the expression.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Click to expand...
 
Gary said:
Fixed that problem, I no longer get a prompt to enter a
parameter. The total is not right. I have 2 records in
the database. Record 1 has a value of 1 and record 2 has
a value of 2 in the same field. That should sum to 3 but
my report says 1.

What now?
Click to expand...

Are you previewing the report using the "Layout Preview" or "Print Preview"?
The former quickly loads the report with sample data for checking the layout,
but will not produce accurate results.
 
I am using Print Preview, Layout Preview is greyed out.
I printed the report to paper and still got a total of 1
insted of 3
 
Back
Top