ORDER BY Syntax Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to use the ORDER BY clause in my SQL. However, I keep getting
errors. Any suggestions on what's wrong? Thanks for your help!

"SELECT Order.OrderID, Order.[Order#],Order.OrderModules,
qryMachDetail.MachDetail, qryMachDetail.JobNo,
qryMachDetail.SerialNo, qryMachDetail.Model " & _
"FROM [Order] INNER JOIN qryMachDetail ON Order.OrderID =
qryMachDetail.OrderID " & _
"WHERE [Order].[OrderID]= " & Me![OrderID]
"ORDER BY qryMachDetail.SerialNo;â€
 
Jody,
I don't see a space before the keyword ORDER. Maybe that's
the cause.
Geof Wyght.
-----Original Message-----
I'm trying to use the ORDER BY clause in my SQL. However, I keep getting
errors. Any suggestions on what's wrong? Thanks for your help!

"SELECT Order.OrderID, Order.
Click to expand...
[Order#],Order.OrderModules,
qryMachDetail.MachDetail, qryMachDetail.JobNo,
qryMachDetail.SerialNo, qryMachDetail.Model " & _
"FROM [Order] INNER JOIN qryMachDetail ON Order.OrderID =
qryMachDetail.OrderID " & _
"WHERE [Order].[OrderID]= " & Me![OrderID]
"ORDER BY qryMachDetail.SerialNo;â?

.
Click to expand...
 
According to the error message, looks like you are correct. However, I'm not
sure where to insert the space. I'm not very good with VB. Here's the error
message:

Syntax error (missing operator) in query expression
'Order.OrderID=221ORDER BY qryMachDetail.SerialNo'

Thanks for your help.


Geof Wyght said:
Jody,
I don't see a space before the keyword ORDER. Maybe that's
the cause.
Geof Wyght.
-----Original Message-----
I'm trying to use the ORDER BY clause in my SQL. However, I keep getting
errors. Any suggestions on what's wrong? Thanks for your help!

"SELECT Order.OrderID, Order. [Order#],Order.OrderModules,
qryMachDetail.MachDetail, qryMachDetail.JobNo,
qryMachDetail.SerialNo, qryMachDetail.Model " & _
"FROM [Order] INNER JOIN qryMachDetail ON Order.OrderID =
qryMachDetail.OrderID " & _
"WHERE [Order].[OrderID]= " & Me![OrderID]
"ORDER BY qryMachDetail.SerialNo;â?Â

.
Click to expand...
Click to expand...
 
Jody,
The best place the add the space is here:
" ORDER BY qryMachDetail.SerialNo "
just before the keyword "ORDER".
Geof Wyght
-----Original Message-----
According to the error message, looks like you are correct. However, I'm not
sure where to insert the space. I'm not very good with VB. Here's the error
message:

Syntax error (missing operator) in query expression
'Order.OrderID=221ORDER BY qryMachDetail.SerialNo'

Thanks for your help.


Geof Wyght said:
Jody,
I don't see a space before the keyword ORDER. Maybe that's
the cause.
Geof Wyght.
-----Original Message-----
I'm trying to use the ORDER BY clause in my SQL. However, I keep getting
errors. Any suggestions on what's wrong? Thanks for your help!

"SELECT Order.OrderID, Order.
Click to expand...
[Order#],Order.OrderModules,
qryMachDetail.MachDetail, qryMachDetail.JobNo,
qryMachDetail.SerialNo, qryMachDetail.Model " & _
"FROM [Order] INNER JOIN qryMachDetail ON
Click to expand...
Order.OrderID
=
qryMachDetail.OrderID " & _
"WHERE [Order].[OrderID]= " & Me![OrderID]
"ORDER BY qryMachDetail.SerialNo;â?Â

.
Click to expand...
Click to expand...
.
Click to expand...
 
Thanks -- it worked!

Geof Wyght said:
Jody,
The best place the add the space is here:
" ORDER BY qryMachDetail.SerialNo "
just before the keyword "ORDER".
Geof Wyght
-----Original Message-----
According to the error message, looks like you are correct. However, I'm not
sure where to insert the space. I'm not very good with VB. Here's the error
message:

Syntax error (missing operator) in query expression
'Order.OrderID=221ORDER BY qryMachDetail.SerialNo'

Thanks for your help.


Geof Wyght said:
Jody,
I don't see a space before the keyword ORDER. Maybe that's
the cause.
Geof Wyght.
-----Original Message-----
I'm trying to use the ORDER BY clause in my SQL.
However, I keep getting
errors. Any suggestions on what's wrong? Thanks for
your help!

"SELECT Order.OrderID, Order.
[Order#],Order.OrderModules,
qryMachDetail.MachDetail, qryMachDetail.JobNo,
qryMachDetail.SerialNo, qryMachDetail.Model " & _
"FROM [Order] INNER JOIN qryMachDetail ON Order.OrderID
=
qryMachDetail.OrderID " & _
"WHERE [Order].[OrderID]= " & Me![OrderID]
"ORDER BY qryMachDetail.SerialNo;â?ÂÂ

.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top