[AccessD] Query problem

Hi S

> 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!!

Well

  Select * From tblSD Where Filename = 'Filename1';

will do that.
But that's too obvious. What are you trying to do?

/gustav