From the attached file, I would like to build few queries in access that gives me following results:
Query1: Circle Wise --- > Unique Main Site Id
Ans: HAR: 673 JK: 534
Query 2: Circle Wise ---> Repeat Sites>4
Ans: HAR: 146 JK:83
Query 3: Circle Wise ----> Unique Sites
Ans: HAR:673 JK:534
Can u help me build these queries as I am using access for 1st time...
thanks in advance.
Bookmarks