Search results

  1. B

    Need help with data mismatch

    This is code to run a filter on a report using two multi-select list boxes. It was working fine before, and then I changed the [FY] or fiscal year data in all associated tables from text to number, and now it won't work. The debug stop on the highlighted line, not sure what that means. Let me...
  2. B

    13 month average calc (but only 12 months per record)

    Please see attached to help understand what I'm trying to do. I'd like to calculate a 13 month average May - April, with the 13th month being the previous year's April (so essentially April to April). How can I add that previous month's April to the detail of the report. I've also attached...
  3. B

    Report Calculation based on Detail Criteria

    The report displays monthly flow (as columns) of inventory for 5 fiscal years (as rows) by product. I'd like to add a calculation with each break in product that would show the difference only between 2011 and 2010 but still display the detail behind the other years. The fiscal years are...
  4. B

    Filter Report based on Multi-Select Listbox

    Forgive me, I don't know much code and looking for some help. Access 2007 WXP user. As the title says. Listbox is called Brandlist Command Button is called Command12 Report is called Inventory$Crosstab Field which will be the filter is called [Brand] I've tried other codes posted on...
  5. B

    Pivot Charts Printing with Black Background

    I have a report with three charts on it. Two of them are PivotCharts created via the Form function and the third is a chart created directly within the report. For some reason, my two Pivot Charts are printing with black background. Anybody have this problem before? Any solves? I've checked...
  6. B

    Button that prints multiple reports with different parameters

    So I currently have a form which has 5 different options (parameters) to select in order to generate a report, each report will look different as each parameter contains a different set of data. Am I able to create a button which will generate all 5 reports with one click so i don't have to...
Back
Top Bottom