I'm trying to add a Latest Added section to my site for the downloads etc but i cannot seem to get the date right(i'm assuming that's what it it) because it works to a certain point but then it will just show more than 20 results.. it shows all results from say a month of updating? any1 could point me in the right direction that would be great. thanks for reading.

strSQL = "Select LATEST 10 * "
strSQL = strSQL & "From wall "
strSQL = strSQL & "Where date> ()now " - this is where i am stuck
strSQL = strSQL & "ORDER BY date DESC"

Try this
strSQL = "Select LATEST 10 * From wall Where date > "&now()&"
ORDER BY date DESC"

Is LATEST a SQL function? If not then use TOP instead. That will only return the top ten results

Yeh sorry i am not too good at this. I have tried this but it brings pretty much all the results with a date?

strSQL = "Select TOP 10 *"
strSQL = strSQL & "From wall "
strSQL = strSQL & "ORDER by date > now()"

Thinking about it, if that was to return the results, would that return the results within the last 24 hours? or a date greater than todays? I basicaly want to return the latest videos i have added within the last 24 hours as i update daily. thanks for your help.

In that case you don't need to use TOP since you don't know how many records there will be. You just need to work out your WHERE clause to pick only records with a date that's in the last 24 hours.

SELECT *
FROM wall
WHERE Date > @MyDate
ORDER BY Date

@MyDate should be worked out as now() minus 24 hours. (I've used an SQL Pareter bt you can also use string concatination)

p.s. "ORDER by date > now()" is invalid SQL. ORDER BY just specifies which column(s) to sort the data on, so "> now()" is irrelevant. Comparisons should probably go in your WHERE clause.