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. FlakyJake

    Complex SQL Query

    LesPaul Just think of it as a big text file, and not in a columnar format, ie some columns will have extra info, so pushes other columns out to right. Hence messy import which makes queries a pain as you cannot specify one field. Richard Not very comfortable with vba, mainly used dbases on...
  2. FlakyJake

    Complex SQL Query

    Thanks Richard that is extremely helpful. No this is a one time migration from an old bookings database. I would under normal conditions normalize but that is a huge task in itself and as with ALL clients time is against me.. I have created two tables now ,BOOKINGS and NO BOOKINGS. However the...
  3. FlakyJake

    Query based on values in another table

    Data structure - Master table with 60 fields, unix import as below. 0000388,Active,MR,M,abc,5 Wave Drive,,Kansas,Kent,DT6 1ZX,UK,01999 123456,SAME,,Aþ0000388,0105297,Firm,12469,10/08/02,OC,12470,12580,12584þ0000388,Broch BH98,0010884,05/11/97,11/03/98,OC,MAIL4,,Encl...
  4. FlakyJake

    Concatenate data from one field to two fields in a table

    Howdi AceMan Can't help you with the delimiter, it was an export from a unix flat file. Can't seem to get a grip with what you are doing here. Does this function grab the left characters up until "þ" found. Then I suppose I have to instigate an update function to place it in the...
  5. FlakyJake

    Query based on values in another table

    I am looking to build a query on a number of fields in a amster table based on the "mailing codes" stored in another table. I want to pull off a list of customers in a master table (122,000) that do not have any of the codes listed in the mailing codes table. What would be the best...
  6. FlakyJake

    Complex SQL Query

    I have a table that I have to select out of it all the records that have requested a brochure on their own accord (ie thay have not received a mailer). This enatils searcing all fields, to make sure there is no MAIL4, Encl Ms, etc etc. As this is a UNIX import all the fields are all over the...
  7. FlakyJake

    Concatenate data from one field to two fields in a table

    destination field "email" is in same table.
  8. FlakyJake

    Concatenate data from one field to two fields in a table

    I have imported a large text file (UNIX) into a table. Some of the fields have shifted etc and i have a lot of sorting to do. One key field has the email address then a limiter then booking number, as below xt@abc.fsnet.co.ukþ0000189 I need to ditch the delimiter "þ" then move the...
  9. FlakyJake

    Extract data from one table to another

    could this be a new table? ie created through the append rather than creating initially? thanx
  10. FlakyJake

    Extract data from one table to another

    I have a global table that houses a huge text import. I now want to extract some of that data based on a query into another table to do some work on it. What is the best way to do this?
  11. FlakyJake

    Text import

    I have a text file as below, with over 120,000 records that my client would like to persuse with various search criteria from within Access. would appreciate views and guides on this. Each record houses address details, one copy, booking details could be numerous and brochure details again...
  12. FlakyJake

    unix flat file import

    Thanks, There is no record type, the comma's are just placed there for simplicity, in real life they contain dates, email addresses, booking ref's etc etc. The problem is after the $ that record mey be repeated. Below is one row. 0000388,Active,MR,M,Ball,5 Wave Down,,WHITing,Sussex,so32...
  13. FlakyJake

    unix flat file import

    I am starting a project where my client wants a unix flatfile imported into access. The file contains 120,000 unique records. The records are delimited and the following format. 3801111,,,,,,,,$3801111,,,,,,,,,$3801111,,,,,,,,,,. Whereby the first record is clients name and addressetc then...

Part and Inventory Search

Back
Top