S D
accessd667 at yahoo.com
Thu Jul 8 02:21:25 CDT 2004
Hi group, i've got a query problem. I've got a table in A2k with 27 fields. The first field is "Filename". I've got the following data in the table: Filename Field2, Field3, Field4, etc... "Filename1", blabla, blabla, blabla, blabla, "Filename2", blabla, blabla, blabla, blabla, "Filename3", blabla, blabla, blabla, blabla, I need a query that displays: "Filename1", blabla, blabla, blabla, blabla, Problem: All other fields have diff info for all records!! Any idea how to solve this? TIA VS --------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages!