var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Access db Syntax Error
What's wrong with this query?
ORDER BY [plant_id]
It returns the error:
Systax error (missing operator) in the query expression '[plant_id]
What operator is missing? Please help, thanks.
what's wrong with the query? it's mysql syntax, that's what
for access, try this:
select top 3 * from plant_list order by plant_id
Outstanding... It worked.
But what if I what to "page" thru the data? Can I specify a starting row?
Thanks for your help!
not easily, no
first of all , you need to have a column or columns to order by
to get rows 11-20 in sql server,
in access, i think you have to write actual queries for the inner subselects
select top 10 *
select top 20
order by plant_id asc ) xx
order by plant_id desc ) yy
order by plant_id asc )