Access Reports, going from footer back to header!

  • Thread starter Thread starter deni k
  • Start date Start date
D

deni k

Access 2000 reports!

I know that access processes its reports from top to bottom.
Is it possiable to somehow go from bottom back to the top?
This is the scenario:
If in the report footer if the value in a textbox field is greater
than 100 make the cotrol(s) in report header invisible, keep in
mind that the header comes before footer and access executes
header than the footer?
Is there a way to to this?
Any comments are welcome.
 
What is the control source of the text box in the report footer? Can you
make a copy of it in the report header?
 
Hello!

The control source of the field is the sum of a field in a query,
you get the sum after a grouping in a detail section.
I guess I could make a copy of it and put it the header but
than there would be no value because the value is generated
after the detail section copmletes.
All I want to do is if a value is certain amount in the footer hide
the textbox in the header!
Deni
 
Have you ever tried placing a "=Sum([YourField])" in a group or report
header? This works as it does in a footer.
 
Unfortunatly I can't put it in the header because I get the value only in
the footer.
Is there any other way to overcome this?

Duane Hookom said:
Have you ever tried placing a "=Sum([YourField])" in a group or report
header? This works as it does in a footer.

--
Duane Hookom
MS Access MVP


deni k said:
Hello!

The control source of the field is the sum of a field in a query,
you get the sum after a grouping in a detail section.
I guess I could make a copy of it and put it the header but
than there would be no value because the value is generated
after the detail section copmletes.
All I want to do is if a value is certain amount in the footer hide
the textbox in the header!
Deni
Click to expand...
Click to expand...
 
Apparently you aren't going to tell anyone how your value is being
calculated in the footer. If we don't know how you are computing the value
then I doubt anyone can tell you how to get the value into the header.

I am out of here for about 10 days so if you feel that you want to provide
more information and don't get an answer in this thread, you may want to
start a new thread.

--
Duane Hookom
MS Access MVP


deni k said:
Unfortunatly I can't put it in the header because I get the value only in
the footer.
Is there any other way to overcome this?

Duane Hookom said:
Have you ever tried placing a "=Sum([YourField])" in a group or report
header? This works as it does in a footer.

--
Duane Hookom
MS Access MVP


deni k said:
Hello!

The control source of the field is the sum of a field in a query,
you get the sum after a grouping in a detail section.
I guess I could make a copy of it and put it the header but
than there would be no value because the value is generated
after the detail section copmletes.
All I want to do is if a value is certain amount in the footer hide
the textbox in the header!
Deni

What is the control source of the text box in the report footer? Can you
make a copy of it in the report header?

--
Duane Hookom
MS Access MVP


Access 2000 reports!

I know that access processes its reports from top to bottom.
Is it possiable to somehow go from bottom back to the top?
This is the scenario:
If in the report footer if the value in a textbox field is greater
than 100 make the cotrol(s) in report header invisible, keep in
mind that the header comes before footer and access executes
header than the footer?
Is there a way to to this?
Any comments are welcome.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top