User Profile

Collapse

Profile Sidebar

Collapse
behlin
behlin
Last Activity: Jun 22 '12, 07:17 PM
Joined: Nov 29 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Report with subreports that don't show in print preview or printed

    I have a report that has 4 sub report (all created in design mode not VBA). Individually all of the subreport are visible in Print Preview. When I display them as the final report in print preview two of the subreports do not show (currently they have they have 0 balances for)

    I need all of the subreports to show even if they have 0 balances.

    Can anyone help me.
    See more | Go to post

  • behlin
    started a topic Counting Occurrences in Multiple Fields

    Counting Occurrences in Multiple Fields

    I am using Access 2007.I have a table that contains 14 ink fields. The ink colors could occur in any of the fields but only once per record. I need to calculate the number of occurance for each individual ink color that appears in the table.

    ink1 ink2 ink3 ink4 ink5 ....... ink14
    red blk purp Yellow blue
    WH Bl Yellow purp red
    blk wh bl red purp

    Any one...
    See more | Go to post
No activity results to display
Show More
Working...