Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by maxie3
-
LINQ querying question
I am new to LINQ...I'm not sure if what I want to do can be done within a query, but maybe one of you LINQ experts can tell if so, and if it can, hopefully show me how. Here's the situation: I have 3 files, whose names I have stored in a string[]: string[] files2use = new string[]...- maxie3
- Thread
- Replies: 0
- Forum: C# (C sharp): Microsoft
-
DISTINCT query?
A friend pointed out that if I add the DISTINCT in the subquery, everything would work....so here's the final query: SELECT Sum(close), Avg(close), inputdate, ticker FROM table1 WHERE date in (SELECT distinct top 2 date from table1 WHERE date <= inputdate ORDER BY date DESC) GROUP BY ticker...- maxie3
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
DISTINCT query?
Well, I was hoping to solve this problem without creating new procedures, functions, etc. For what it is worth, this is what I had so far.... SELECT Sum([table1].[close]) AS sumOfClose, Avg([table1].[close]) AS avgOfClose, inputdate AS MADate, [table1].[ticker] FROM table1 WHERE...- maxie3
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
DISTINCT query?
I've got a problem for you Access/SQL gurus out there... I am using Access 2000. This problem involves Table1 with these columns: date, ticker, close. This table is updated daily with the closing prices of various stocks. I am trying to develop a query that prompts me for a date (we can...- maxie3
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
