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: ckabi
  • Order by date
  1. ckabi

    Many rows to one column...

    I thought this would be very simple, but I can't seem to figure it out ... from this table: phID usID phone 1 1 555-1212 2 1 555-2121 3 2 555-9955 I want this view: usID calcphones 1 555-1212 555-2121 2 555-9955 where calcphones is a calculated...
  2. ckabi

    How to select one record from many

    I would like to do something similar... from this table: phID usID phone 1 1 555-1212 2 1 555-2121 3 2 555-9955 I want this view: usID calcphones 1 555-1212 555-2121 2 555-9955 How can I do this?

Part and Inventory Search

Back
Top