S D
accessd667 at yahoo.com
Thu Jul 8 05:41:06 CDT 2004
No that didn't do the trick. The problem is I do NOT know the values! So it's not just the first word (filename could be: customer01.xls, customer02.xls) It gets the first word, true but it didn't solve the problem. As mentioned before there are a lot of other fields that need to be displayed... A real nasty one. I've got some SQL-guru's over here looking at the problem. They've came up with the most exotic things..none of them worked. I'll have another look at it. Thanx anyway. Sander Gustav Brock <gustav at cactus.dk> wrote: 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 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------- Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish.