Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rpatel18

  1. rpatel18

    spliting up a table into multiple tables

    So I can just keep the table with all the 74 cats in them(column 1) and make the zip code primary on that table(column2) and just make a one to many relationship? If this is the case, i feel like an idiot then....lol
  2. rpatel18

    spliting up a table into multiple tables

    so should I just use a one to many relationship?
  3. rpatel18

    spliting up a table into multiple tables

    I dont see how I would only need two tables with 74 categories all containing 30,000+ zip codes. The 74 categories also have to be linked to IRS data and census data both with the primary key of zipcodes.
  4. rpatel18

    spliting up a table into multiple tables

    well, each subcat has all the zip codes in the US with certain information regarding that zip code. All the other data has a primary key of zipcodes, splitting the table apart would let me link to those sub cats.
  5. rpatel18

    spliting up a table into multiple tables

    how would I loop 74 different queries?
  6. rpatel18

    spliting up a table into multiple tables

    I just used the build querey feature in access and edited it. I have limited knowledge about access and sql. I'm only a intern and a college sophmore trying to compile databases and create reporting tools for the company I work for.
  7. rpatel18

    spliting up a table into multiple tables

    all of them aren't the same, they are slightly different. I have 74 subcategories in one table, and I need to split all those 74 subcatogories into their own tables.
  8. rpatel18

    spliting up a table into multiple tables

    they all run fine individually but i dont feel like running 74 individual queries.
  9. rpatel18

    spliting up a table into multiple tables

    I'm trying to split a table into multiple tables. The code I'm using is the following but I keep getting a syntax error in querey expression. SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004...
  10. rpatel18

    excel macro programming....

    I used this macro: Sub RunCodeOnAllXLSFiles() Dim i As Integer Dim wbResults As Workbook Dim wbCodeBook As Workbook Application.ScreenUpdating = False Application.DisplayAlerts = False Application.EnableEvents = False On Error Resume Next Set...
  11. rpatel18

    excel macro programming....

    I have the following macro in excel.. Sub replace() ' ' replace Macro ' Macro recorded 6/18/2007 by LISC USER ' Range("B1:CM4000").Select Selection.replace What:="** ", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _...
  12. rpatel18

    Combining multiple identical tables into one

    DTS?
  13. rpatel18

    Combining multiple identical tables into one

    well, I have it in excel, and import it to access(more comfortable working in access), and then it'll get imported to sql server.
  14. rpatel18

    Combining multiple identical tables into one

    I'm going to try and normalize the data in excel(came in excel format), take out all the none numerical values since there should only be numbers in there(many fields have $,-, and *) and then try to re-import them. I think the issue is I can't combine them because some fields are text fields in...
  15. rpatel18

    replacing *'s

    the fields right now are defined as text fields but they only contain numbers.
See more

Part and Inventory Search

Back
Top