[AccessD] Query problem

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

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

		
---------------------------------
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!