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 derfloh 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. phaeberle

    Mask for SSN field

    This can only be done through a calculation field. If you have SSfield (where the users are going to enter the SS) You have to create a calculated field cSSfield that contains the following formula: Left(SSfield, 3) & "-" & Middle(SSfield, 4,2) & "-" & Right(SSfield,4) In...
  2. phaeberle

    Changing Values

    Check the "substitute" function
  3. phaeberle

    Query "something" or "somethingelse"

    Create a calculation field and concatenate both, address1 and address2 (address1 & " " & address2). When entering in find mode, change layout and perform the search in the calculated field, not in address1 or address2

Part and Inventory Search

Back
Top