Whats wrong with Query Syntax, not returning proper set

[ilcaa]

I definetly have the data in my DB because I can see it, but this query will not return the right data.

I basically want to return the top 5 data points before this date (earlier) but including the date.

select TOP 5 qDate, from Quotes WHERE qTicker='goog' and qDate <= #3/17/2015# ORDER BY qDate DESC;

so this should return.

3/17/2015
3/16/2015
3/13/2015
3/12/2015
3/11/2015

*please note, it doesn't return 3/15 or 3/14 because it doesn't exist in my database. So starting with x date return this date (data point) and the 4 previous dates (or data points within qDate field)

 

[Joe4]

You have an error in your SQL code. There should not be a comma after the word "qDate".
Also make sure that the data type of the qDate field is Date and not Text.

 

[ilcaa]

its not that it returns an error, is just doesnt return the right data set. It results do not start with the date specified in the query (3/17/2015), also the column is a Date colume with short-date

where is the error in the Syntax? which qDate in the query are you referrring to that is missing the comma?

 

[Joe4]

The comma at the end of this part:

[COLOR=#333333]select TOP 5 qDate[/COLOR][COLOR=#ff0000][B],[/B][/COLOR]

should NOT be there.

Can you tell me what this query returns?

[COLOR=#333333]select count(*) from Quotes WHERE qTicker='goog' and qDate <= #3/17/2015#;[/COLOR]

 

[ilcaa]

sorry I mis-read your post about the comma. The count return of your query is 231,

 

[Joe4]

OK, so that selection criteria finds 231 records. And what happens if you run this:

[COLOR=#333333]select TOP 5 qDate from Quotes WHERE qTicker='goog' and qDate <= #3/17/2015# ORDER BY qDate DESC;[/COLOR]

Does it return nothing at all, or just unexpected results?
If unexpected results, what does it return?

 

[ilcaa]

thanks for trying to help out, I appreciate it. I ended up deleting the Access DB, downloaded all the data from scratch and was able to get it to work properly. your query above returns the right values, thanks again