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

    Removing spaces and all text to the right

    How would I go about removing unwanted spaces from a text string and all text to the right of this? e.g. "xx1 pl5605" -----> xx1 "g8 jj77" -----> g8 I've tried various combinations of trim and clean but can't get them to work. Please note that there can be any number of spaces but I...
  2. captainquigers

    Creating queries and forms so data can be manually updated

    I have a table that contains a single field. The data in the field is a contact salutation for an account holder, e.g. Mr Bob Smith & Mrs Julie Smith I need to create a new table with this information normalised e.g. Original Data Title1 First Name1 Surname1 Title2 First Name2 Surname2 The...
  3. captainquigers

    How do I select data from several different tables?

    I have several tables with the same schema containing monthly financial data. I would like to create a form so that users can select which of the tables are queried when requesting data. The naming convention for the tables is as follows; 200404 200405 200406 The contents of each table look...
  4. captainquigers

    Rolling up records into bands/sets

    How would I roll up records based upon which band a value lies in? The data looks like this; Field1 Field2 1 48.25 2 12.68 2 98.16 7 12.36 8 67.46 12 46.64 15 45.89 And I would like like the query to output; Field1...

Part and Inventory Search

Back
Top