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!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rinos2

  1. rinos2

    Display records that have same data in some fields

    Please see the data to be displayed below: Name Item# SSN Type Date Status Company Notes xyz 1 5462 a 10/01 Approved uvw test1 xyz 1 5462 b 10/01 Approved abc test2 The above records are for the same person (xyz). I need to display the...
  2. rinos2

    Display records that have same data in some of the fields

    I have a sql query that returns records related to a person. This record has 5-6 fields. The query returns multiple records for this person because 2 fields have different data in the records that are repeated. In the report, I need to display the first record with data in all the fields, but in...
  3. rinos2

    Display filtered data in a table

    Thanks a bunch for your tips on soving this problem!
  4. rinos2

    Display filtered data in a table

    Hi All, I need to display results from a query based on a a certain field (the field is state in my case). I need to display the same fields in the table but the filter criteria is different (in first case I need to display all fields from the query where state is like California and in the...

Part and Inventory Search

Back
Top