Let say AP is randomly placed at any level. Q1. How to assign each AP to the floor such that each floor have exactly 2 AP?? Is it use query??
I have a Users table where all the data captured by the AP are inserted as well as a Valid_Users table where all the valid mac address are stored.
Then, to divide valid users from intruders, I use 2 queries - qryIntruders and qryValid_Users. I've already manage to do this.
Let say, the mac address of the users are captured at all of the AP. Q2. How to know which Users are from which AP, eg. location of AP?