microsoft.public.access.reports | Forum profile

  Your junction table should only include the primary key from the QryStaff List and tblEduationOfferings. You can add other information that is not in the other tables. This can be implemented using the solution I suggested previously.

  Pedro wrote: >I've made a simple report but with just the objects on the footer section. >12 lines each one with 13 objects, like an anual report. So far so good. It >shows me all the way i want. But i would like to add 8 lines more with >another 13 objects per line. The weird thing is that, it adds my first page >in blank. Completly in blank. Nothing. the 2nd page with the results and 3rd...

  A crosstab query will do it for you. TRANSFORM Sum([Dollar Amount]) AS SomOfDollar SELECT [Item] FROM YourTable GROUP BY [Item] PIVOT [Month];

  You can use the expression on each page in the Page Header or Create a top-level group based on the expression =1 Add a control to this top-level group Set the control's control source to the = The expression I posted Set the Top-level group's Repeat Section property to Yes (True) so that it will repeat on every page. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore...

  Karl, do you have any other suggestions?

  When I close my report, some of my code that controls the left margin for odd-even pages runs many times before the report actually exits - it's in some kind of loop but does eventually close. The code in my report is as follows: Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) If Me.Page = 1 Then MoveMargin = 360 ElseIf Me.Page Mod 2 = 0 Then MoveMargin = -360 Else MoveMargin = 360 End If...

  Write now here is my structure, part of the problem is that I a novice Access user, and my supervisor wants a lot of variable built in. There are some subTables that you don't really apply to this issue. QryStaff List (Built off of ODBC Linked Tables) ====================== client_id last_name first_name Discipline Position Dept login-id team_name date_of_hire date_of_term active tblEducationOfferings ================== ID#...

  Can anyone out there tell me if I can make the appearance of a footer conditional upon whether or not there is null data in a particular field? For example, a field in my table is called "Staff_Section." Some records contain a staff_section while others do not. For sections that do not have a staff_section identified, I do not want their numbers to be summed in the Staff_Section footer. For records that have a...

  You've described how you want your reports to look ... but not what your underlying data looks like. "How" depends on "what"... More info, please...

  There are some tips on avoiding corruption here http://www.allenbrowne.com//ser-25.html You need good backups. If the work you have just completed took a lot of time and effort and you don't want to lose it, then back it up. There is no need to wait till you close the database. In A2007 you can go Alt + F + M + K to backup. Create a folder called backups. Save the first backup to the folder. After that access will remember...