Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Chicago, IL

    Unanswered: Even Number Of Records

    I have a subform that shows data in two columns. The data has lines around it and it looks odd if there are an odd number of records returned. So I looking for a way to add a blank record if there is an odd number of records returned. Anyone got any suggestions? Note, I will not know how many records will be returned and I have to show all of the records ( I can't return the Top N records, where N is less than the number of records).

  2. #2
    Join Date
    Feb 2005
    Peoria, IL, USA
    You can use the MOD function on the number of records to determine if it is even or odd, then add a record if it is odd.

    However, you might be able to get the visual effect you want on the report without creating "dummy records." An outline around your entire subreport should give you the visual balance you're looking for.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts