Query Between Starting Date & +10 days

[ilcaa]

I have a Table, "Quotes", that is structured

qDate, qTicker, qHi
4/20/2015, goog, 540.93
4/19/2015, goog, 539.30
4/18/2015, goog, 537.10
....
3/19/2014, goog, 539.30
3/18/2014, goog, 537.10

I would like to run a query that returns the qHi of "goog" BETWEEN a given start date and 10 days forward.
I have, which gives me syntax error.

Select DistinctRow Max(Quotes.qHi)
From Quotes
Where ((Quotes.qTicker)= "goog" and
Where Quotes.qDate Between 2/10/2014 AND DateAdd("d", 2/10/2014, 10));

so it would return the MAX value of column qHi between 2/10/2014 and 2/20/2014.

 

[Joe4]

Try:

SELECT Max(Quotes.qHi)
FROM Quotes
WHERE (Quotes.qTicker="goog") 
AND (Quotes.qDate Between #2/10/2014# And DateAdd("d",#2/10/2014#,10));

 

[ilcaa]

Hi Joe,

Thanks that DID work. But i found another issues with date + 10days. Since these are stock values the query includes weekend dates. What I really need is the Max value of next 10 Values from the Date provided. Here is an example, if i used 2/2/2015, and used DATES Max value would be 543.19 because it would include the weekend dates of 2/7 & 2/8. But I want the next 10 values, so 549.00 would be the answer.

Can you adjust the query for next 10 values after Start Date? Thanks for any help.

2/2/2015 533.00
2/3/2015 533.40
2/4/2015 532.67
2/5/2015 528.50
2/6/2015 537.20
2/9/2015 538.45
2/10/2015 540.20
2/11/2015 544.82
2/12/2015 543.19
2/13/2015 542.21
2/14/2015 549.00

 

[Joe4]

That changes the problem entirely and makes it much more difficult. Not sure how you would do that with somehow ranking the records, or sorting them and using recordsets and VBA.

 

[ilcaa]

no that critical if its that much more complex, doesnt throw off point of the project.

thanks for the help