14 Replies Latest reply on Jul 3, 2009 4:57 PM by comment_1

    need help with reporting on conjunction of two fields

    rafi

      Title

      need help with reporting on conjunction of two fields

      Post

      I have a table containing (among other things) two fields defining the cross-streets of an intersection. Multiple records can refer to one intersection. I want a report listing how many records pertain to each intersection, sorted by declining value.

       

      The issue is that the intersection of Your Street crossing My Street is actually the same intersection as My Street crossing Your Street. If the table contains 5 records of Your Street/My Street and 8 records of My Street/Your Street, how do I arrange things to get a report showing 13 records pertaining to that one intersection?