Search results

  1. H

    Listing numbers in field?

    I'm adding a bunch of rows with data into a table, and one of my fields is "ID number", which is just basically number the row in consecutive order before duplicates are removed. How can I make a query that will do this? So for instance the query would fill in "1", "2", "3", etc. depending on...
  2. H

    Running Multiple queries at the same time?

    Is this possible? I have about 8 queries I'd like to just run at one time. Perhaps with a macro?
  3. H

    Help with IIF statement

    So I have an IIF statement that I ran and it outputs the data the way I want it to. The only thing I dont know how to do is how do I take the data/results I get from running the query and put it into a specific column in a table?
  4. H

    Need some help with a "VLOOKUP" type of command

    I'm basically trying to perform a VLOOKUP in SQL but I can't seem to get it to work... heres the code I'm trying SELECT Cities FROM tblMetroAudCLcity WHERE Citytype='Info2.area'; Returns an empty table for me :-(
  5. H

    Removing Duplicates?

    Hi all, I'm trying to check for duplicates in a table, and if found, delete the corrosponding row. There are several thousand records in the table however, so I'm also trying to run this as fast as possible. Any help would be great! Thanks!
Back
Top Bottom