Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: slud
  • Order by date
  1. slud

    Looking at a row of data before printing

    G: The page is indeed about half a sheet long so that 2 records fit within the space. When I tried setting the Repeat Section to 'yes', and I (accidentally) clicked to go to the last page (of preview), the program went into some non-responding loop, so that I had to abort it. Later when I reset...
  2. slud

    Looking at a row of data before printing

    G, Your suggestion has made a change--the report now produces a definite break between plan names. A new page is developed when the plan name changes. This seems to be good, but without the other part of the problem, I can't really tell. I still need the ability to print 2 consecutive records...
  3. slud

    Looking at a row of data before printing

    Ginger, The report already has a header, I didn't need to create one. Within the report header the Sorting and Grouping property says to sort/group by PlanName, ascending. I think that's there because of the sql statement saying "ORDER BY ....". Right? Is there something more needed...
  4. slud

    Looking at a row of data before printing

    Thanks Ginger. My report already has the features you suggested. But what is NOT there is the ability for 2 successive records for the same plan to print on one sheet--one at the top of the sheet and one at the bottom.
  5. slud

    Looking at a row of data before printing

    Ginger, the db is relatively simple--3 tables, one dealing with plan data, one with personnel data, and one with company information. The actual sql query is as follows: SELECT ExEmployees.PlanName, ExEmployees.EmployeeLastName AS Expr1, ExEmployees.EmployeeFirstName AS Expr2...
  6. slud

    Looking at a row of data before printing

    To GingerR, the answer is Yes, I still need assistance. And yes to the question of automating this. I definitely would like the complete report to self-generate.
  7. slud

    Looking at a row of data before printing

    I'm new to Access, but not new to s/w development. I'm using Access 97, but with some documentation of an earlier version, so I'm not sure what I can or can't do about my task. I need to process the records from my query, and sometimes print two on one sheet/report, and sometimes not, depending...
  8. slud

    Output to a 2-part report

    I have a 2-part report--the top is basically duplicated on the bottom. I have a sorted db based on a field "plan name". The task is to maximize use of both parts of the form while the "plan name" stays the same, and then when the plan name changes, the new plan's data goes on...

Part and Inventory Search

Back
Top