Search results

  1. A

    How do you limit data to just TOP RANKED rows

    Hello, I was trying to get only the TOP RANKED rows from a table like this, using a query. Here is my data: The result would be a table showing only the yellow shaded rows, which are those where the "fruit count" is the highest. I tried with a "group by max", but as expected I do not get what...
    • abq
    • Thread
    • Replies: 6
    • Forum: Queries
  2. A

    Access 2003 <=> SQL 2005 Best Practices - Part II

    If you read a previos post of mine, I am working on an application, trying to move the back-end part to an SQL Database. What I am starting from, is a "classic" Access 2003 application splitted in 2 parts: the front end with the application consisting of "fixed data" tables, queries, forms...
  3. A

    Access 2003 <=> SQL 2005 Best Practices

    Hello everyone. After some years using just Access for my application (everithing going fine), I am now testing the switch to SQL server 2005. I already have an application divided in two parts (Data and Program), so I used the "Microsoft SQL Server Migration Assistant for Access" to port my...
  4. A

    VBA Code to Link SQL Server Tables

    I think this is a common issue for all those people who are upgrading from access to SQL server (as database), so i'm asking where i can find some resource to accomplish the following "basic" task. The following command is used to attach an Access Table contained in an .mdb file...
Top Bottom