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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- rinos2
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
-
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...- rinos2
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Display filtered data in a table
Thanks a bunch for your tips on soving this problem!- rinos2
- Post #3
- Forum: Microsoft: Access Reports
-
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...- rinos2
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
