Recent content by Gustavson

Jim - thanx for your reply. I set the report property page footer to all pages and it works great now.. Gustavson

Any ideas? Anyone?

okay - I figured it out. The subreport header needs to be in the subreport's report header section. thanx Gustavson

I'm using access 97. I have a sub report in the Report Header of my main report. When I view my sub report in print preview mode, I see a header. When I view my main report in print preview mode, I only see the detail section of my subreport and not the page header. Any ideas on how to fix...

ssecca - okay, subreport worked good... Thanx for your reply. Gustavson

Paul - thanx that worked great Gustavson

I'm using access 97. How do I display data only once in a query? Can I add something to criteria to only allow data to be displayed once. For example: red green blue Not: red red red green green blue Hope this enough info.. Thanx Gustavson

I'm using access 97. I'm generating a report that displays information on buildings and chemicals stored in those buildings. The report is generated from a query. In the report header I am trying to generate a list of just the buildings so that they are displayed on the first page. There...

I'm using access97. In my report the page number doesn't display on the first page but every page there after. Any ideas on how to get the first page to display page number as well? Here's the code that I am using to display page numbers: ="Page " & [Page] & " of " &...

okay, I just had to mess around with some properties within the Headers and Footers on my report and used the =Sum([Quantity]) expression to run the sum.. Works good now.. Thanx for your help Gustavson

Robert thanx for your reply. I read into grouping and using running sums. This is what I did so far. Added a new footer based on Building. I set the properties to Group On Each Value and Keep Together Whole Group. Added a text box to the footer and set the source to quantity, and set the...

I'm using access97. I have a query in which I have many fields. Building, room number, chemical, quantity are four of the many fields that I have in the query. As of right now I am grouping by buildings , room numbers and chemicals. That works just fine but I can't figure out how to keep a...

I'm generating a report in access97. I have a control box in which text is displayed. If the text in the box is too long it gets cut off at that point and part of it is missing when printing the report. Is there a way to automatically adjust font size if the text is too long for the control...

okay - here's a little more info.. I have three headers.. I have to use three headers in my report in order to group and sort properly. I need these to stay together though.. I don't want one header on one page and another on the next page. I would really like to set it up so that if one...

I'm using access97.. Is there a way to set repeat section to yes and not display any information on the previous page.. so I like the data to be displayed on a new page but not on the old page.. Thanx Gustavson