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!

Search results for query: *

  1. Rjconrep

    [b]Compare data layouts[/b]

    Thanks a bunch Trojan
  2. Rjconrep

    [b]Compare data layouts[/b]

    I need to import all of these files into a program that will sort all of the records for the mail stream. I am using an import template so before I import these files I need to verify that all of the data files are formatted the same. All of the files are in one folder and they are all excel...
  3. Rjconrep

    [b]Compare data layouts[/b]

    Thanks Trojan....at least you have pointed me in some kind of direction. I dont code so this is all new to me as I am sure is obvious. I was told that I could do what I wanted with relative ease using a perl script. I am sure I will figure it out.
  4. Rjconrep

    [b]Compare data layouts[/b]

    I have a folder that contains 500 different lists. I need to create a perl script that will compare each of these files to a master file layout and verify that they are all the same. I need it to log which files don't match the master layout.
  5. Rjconrep

    APPENDING RECORDS

    You guys are awesome are the man!!! Harley, I had my Sum1 Table set up incorrectly. I fixed it, ran it and it worked perfectly. thanks a bunch!!!
  6. Rjconrep

    APPENDING RECORDS

    You were right Harley. :-) I can see that my naming convention was not the best here. When I run this query; INSERT INTO Final ( ID, FacID, [Loc #], [Inn Code], Brand, Rooms, TableTents ) SELECT ID, FacID, [Loc #], [Inn Code], Brand, Rooms, TableTents FROM Samples, Sum1 WHERE...
  7. Rjconrep

    APPENDING RECORDS

    Okay, I think I am getting closer. This is the query that I ran; Insert INTO Final ( ID,FacID,[Loc #],[Inn Code],Brand,Rooms,TableTents) SELECT ID,FacID,[Loc #],[Inn Code],Brand,Rooms,TableTents FROM Samples, Sum1 WHERE Sum1.TableNumbers= Samples.TableTents; Problem is that it didn't repeat any...
  8. Rjconrep

    APPENDING RECORDS

    Here is what I now have; Insert INTO Final ( ID,FacID,[Loc #],[Inn Code],Brand,Rooms,TableTents) SELECT Samples ( ID,FacID,[Loc #],[Inn Code],Brand,Rooms,TableTents) FROM Samples, TableNumbers WHERE Sum1.TableNumbers< Samples.TableTents; This is giving me the following error; "number of query...
  9. Rjconrep

    APPENDING RECORDS

    So would i use an Update Query? I am not sure I understand....sorry.
  10. Rjconrep

    APPENDING RECORDS

    I have an Access table that has the following fields; FacID Loc # Inn Brand TableTents 3864 1179 RWCEX.pdf HIEX 75 5749 7629 SFOPF.pdf HEXS 75 7258 4648 YRMAB.pdf HIEX 75 I need the records in the table to repeat based on the "TableTents" field. This is what I have written so...
  11. Rjconrep

    Select Records

    This is what my table looks like now: Contact Name OtherField1 OtherField2 Rhonda Adcox data data Donna Miller data data Chuck Adcox data data Linda True data data This is what I have written so far and it works but I want a query that...
  12. Rjconrep

    Select Records

    I am trying to get information on how best to right a query that would produce a table with 20 of each sales rep in it from another table.
  13. Rjconrep

    Select Records

    I work for a print house and our client wants to see sample data for each sales rep within the file. 20 records of each to be exact. We use the data to create print proofs.
  14. Rjconrep

    Select Records

    I have a table that has 17 sales representatives (over 15,000 records). How can take 20 records from each Sales Rep and put them into 17 different tables?
  15. Rjconrep

    Decyphering fields based on another tables information

    I want a seperate field for each description.
  16. Rjconrep

    Decyphering fields based on another tables information

    Yes, I know but this is how I received the data. Any suggestions?
  17. Rjconrep

    Decyphering fields based on another tables information

    I have two tables one table is called BuyerGuideCodes and the other is called BuyerGuideCodesDescriptions. Below is a sample record of table BuyerGuideCodes: ID: 1 COMPANY: CJ Systems Aviation Group CodeID: SS, OP, AS, AL, AN, AO, BS, GA, HD, IT, RO, PS, TR, MK...
  18. Rjconrep

    JOIN tables AND ORDER fields

    lespaul: Thanks lespaul! That is exactly what I did and got it all to work fine. mstrmage1768: I suggest you post back,...blahblahblah. Sorry you didn't understand.
  19. Rjconrep

    JOIN tables AND ORDER fields

    I have joined to tables based on Group_ID. This has added nineteen different contact fields to my new table. I need to sort the contact fields according to Position order. see below sorted by postion in the following order: Program Director: Operational Manager: Medical Crew Supervisor: Medical...
  20. Rjconrep

    Export XML from SQL Server

    I am new to both XML and SQL Server so please be patient. I have ten excel files that need to be imported into SQL server. This part of my job is done. What I need now is to export these files as tagged XML files. How do I export as XML from SQL server?

Part and Inventory Search

Back
Top