Search results

  1. U

    Create Query on max

    Thanks. I will try to implement it this way.
  2. U

    Create Query on max

    I tried to do this way, but i got stuck with double variable lookup. Because, I will need to lookup two variables from one with two variables from another to get rest of the fields. Ended up messing it. Thanks for the advice. I will try to change it.
  3. U

    Create Query on max

    Hi, I am new to access. I seek some help creating a query. I have a table with field Date, Time, Traffic, cell, ... I wish to create a query, which gives me one record from this table where Traffic is max, for that cell along with all other fields related to that record. Date Time Cell...
  4. U

    Creating Relationship

    Thanks again catalin, I will have a look at the dB and get back to you. Is there a way of getting in touch with you directly. I cant seem to find a way of sending private message. :( Best Regards,
  5. U

    Creating Relationship

    As I wrote earlier, I am a novice and I am open to all suggestions. :) Kindly find attached typical data input that I am expecting to accommodate in the database in the form of excel sheet. Thanks,
  6. U

    Creating Relationship

    Hi Catalin, I will try my best to explain what I am trying to achieve and I know I am very bad at explaining things. :( Description of the project below: The project aims to serve as an updated database of a network consisiting of sites with different technologies like 2G, 3G, LTE, and WiMAX...
  7. U

    Creating Relationship

    Thanks Catalin, I will have a look at your modifications. Best Regards,
  8. U

    Creating Relationship

    Hi Catalin, thanks for the reply. Sitedesignpara has completely different set of fields. For each site id (from either of the tables to which it is linked), it may have as large as 9 sector id's. The idea for sitedesigpara is to contain all the sector information for the project. Thanks,
  9. U

    Creating Relationship

    Hi, I have uploaded my database, just in case it helps in explaining my problem. Thanks,
  10. U

    Creating Relationship

    Hi, thanks for the reply. I will be ideally looking to input all the tables with the information. If the status of the site is Planned, I would need to update all the tables. If on the contrary, the site is onair, it will need to have sitedb,sitecodestech, planstatustables(2G,3G,LTE,WiMaX)...
  11. U

    Creating Relationship

    Hi, I am a novice to access. I am building a database in an effort to learn in the process. I wished to enquire about the possible issues that could be with defining the relationships that i have created in the project. (attached img). I cannot seem to define a form based on these...
  12. U

    Hi,

    Hi, I am a newbie to access and trying my luck to develop a database for my department. I have no experience, whatsoever, with the access or for that matter databases, but I was hoping to be able to nail this project. Looking forward to learning from the learned ones here. :) Best Regards,
Top Bottom