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

    Help understand the underneath logic for update

    Suppose I am using a form to update the table. The form is based on a query,say qrTest. The qrTest selects data from the table. Since the table has ssn(primary key), I used right(ssn,4) to select the ssn in the qrTest. Now of course the ssn field in the form only displays the 4 digit of ssn. Now...
  2. xchen88

    display part of column data in Access

    Thanks for the reply. I should have made myselft more clear. I mean the table, not query. When user opens the table, it only displays part of the data. Thanks
  3. xchen88

    display part of column data in Access

    Is there any way to only display part of the data in a certain column, for example, SSN 123-23-4566, I would like to display 4566 only. Thanks

Part and Inventory Search

Back
Top