[AccessD] Query problem

Hi Sander

Well, you need the first word of the filename.

Try selecting on

  Select Distinct
    Left([Filename],
      IIf(InStr([Filename]," ")=0,
        Len([Filename]),
        InStr([Filename], " ")-1)) As File
  From
    tblFiles;

/gustav


> Thanx Gustav! That's exactly what I need!
> Can you please provide me a query for the other 12.000(+) records? Oh, btw I do not know all filenames...yet!
 
> :-) there's a little bit of sarcasme in the above :-)
 
> I need to know which files where accessed during the last 7 days and I want to filter out 'period versioning'. So i've got a lot of files like:
> Customer Aug 03.xls
> Customer Sept 03.xls
> Expens Aug 03.xls
> Expens Sept 03.xls
> etc etc
 
> I want the query to return:
> Customer
> Expens
 
> This way I know how many Excel-apps we've got...remember the 12000 records? that wasn't sarcasme :-(
 
> HTH

> Gustav Brock <gustav at cactus.dk> wrote:
> 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