Search results

  1. G

    VBA code in footer runs twice

    I have a report that has a Detail section, a Group footer section and a Report footer section. The Group footer is based on a field named [Quarter] and it's code should be executed once for each value of this field. My problem is that it is being executed twice for each value of this field, and...
  2. G

    Merging the results of two queries

    I have a table (Approved Item Numbers) that contains a field [ITEM KEY] and [Description]. Part of the table contains records where the ITEM NUMBER is constructed like yyyy-q-nnn (y=Fiscal year, q=fiscal quarter and nnn-sequential number). The other part of the table contains records with...
  3. G

    Commenting blocks of code

    I used to know how to comment out blocks of code, but apparently I've forgotten the steps. I think all I did was highlight the code I wanted to comment and the click on "something". It's the "something" that I've forgotten and can't find any reference to commenting and uncommenting blocks of VBA...
Back
Top Bottom