Build_Queries_Access
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.
I might have missed it, but I don't see an attached file. If it is a .mdb you have to put it in a zip file.
Hope this helps,
Dan
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks