AnsweredAssumed Answered

need help with reporting on conjunction of two fields

Question asked by rafi on Jun 29, 2009
Latest reply on Jul 3, 2009 by comment_1

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?

Outcomes