Query to select specific row from table

[IANGRAND]

I am applying the following query, to select the row number taken from textbox 156, for the table HOURLY_AVERAGE:

SELECT TOP 1 *
FROM [Select top Me!Text156.Text * from HOURLY_AVERAGE order by AvgOfNO2 desc]. AS T1
ORDER BY AvgOfNO2;

However, on running the code the following error is produced:

"The select statement includes a reserved word or statement that is mispelled or missing, or the punctuation is incorrect."

Any ideas how to resolve this problem?

Cheers

Ian