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 gkittelson 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: *

  • Users: lss
  • Order by date
  1. lss

    loop through groups create individual reports

    In Access, I created a parameter query using specific criteria in several fields. The parameter prompts for one more piece of information. The report that calls the query will print data based on the parameter and all other fields publish in two columns. It works well if you want to print one...
  2. lss

    Delete Last Character From String

    If you show: CombinedFieldsList: Field1 & ";" + Field2 & ";" + Field3 & ";" + Field4 & ";" + Field5 and any fields are blank you would see: Field1; Field2; ; ; ; Then you have to chop off however many semicolons and spaces MAY appear...
  3. lss

    Delete Last Character From String

    Thank you! I had to include Trim([CombinedFieldsList]), must be a space at the end somehow (I do have Trim defined on the CombinedFieldsList too), but it does work. I appreciate your help.
  4. lss

    Delete Last Character From String

    This should be a simple task, but I can't find the right coding that will make this work. I've tried combining expressions using Left, Right, Mid, InStr, Replace. In an Access Query we have 5 separate fields. Data is always in Field1. Field2 to Field5 may contain data or may be blank, but...
  5. lss

    Help setting up autolookup query and form

    I've browsed the forums and even checked out Northwinds database. Both seem to include pieces but I don't quite know how to set up what I need. We input new customers in a customers table. It includes the basic info, name, address, city, state, and zip, among other fields. We split up groups...

Part and Inventory Search

Back
Top