Ordering a dynamic query (1 Viewer)

[DBL]

I'm trying to add in an order when I create a dynamic query. This is the code I currently use which creates the dynamic query:

Set QD = db.CreateQueryDef("qryFrmSelectAreas_Dynamic", _
"Select * from tblLookupAreas")

I'm trying to add in a sort by changing this to:

Set QD = db.CreateQueryDef("qryFrmSelectAreas_Dynamic", _
"Select * from tblLookupAreas" & _
"order by tblLookupAreas.Area ASC;")

But I'm just getting a Syntax error. Any suggestions as to where I'm going wrong.

 

[JANR]

You are missing a SPACE before "Order BY...

Set QD = db.CreateQueryDef("qryFrmSelectAreas_Dynamic", _
" Select * from tblLookupAreas" & _
" order by tblLookupAreas.Area ASC;")

JR

 

[DBL]

Doh! Thank you so much.