Problem with Order by statement...

  • Thread starter Thread starter Raymond van der Meer
  • Start date Start date
R

Raymond van der Meer

Hi everyone!

I've got a form with a subform in it.
In this subform I want to see the 4 records with the most recent date.

I'm using this SQL-statement:
SELECT [tblControle].[ControleId], [tblControle].[Hijsmateriaalnummer],
[tblControle].[ControleDate] FROM tblControle ORDER BY
[tblControle].[ControleDate] DESC, LIMIT 0,4;

but this doesn't seem to work...

What is the right way to let Access know what I want to see :p ?

Thank you in advance!

Greetings from the Netherlands,

Raymond
 
Hi everyone!

I've got a form with a subform in it.
In this subform I want to see the 4 records with the most recent date.

I'm using this SQL-statement:
SELECT [tblControle].[ControleId], [tblControle].[Hijsmateriaalnummer],
[tblControle].[ControleDate] FROM tblControle ORDER BY
[tblControle].[ControleDate] DESC, LIMIT 0,4;

but this doesn't seem to work...

What is the right way to let Access know what I want to see :p ?
Click to expand...

I can't quite tell WHAT you want to see! I'm not familiar with the
syntax LIMIT 0,4 - what is it intended to accomplish?

John W. Vinson[MVP]
 
Hi John,

I'm sorry for not being clear...
It was also very late, when I posted that message yesterday-evening. I was
confusing myself :p

I've thought things over last night and have found another way to make
access do what I want :)

But thanks anyway John!

Greets,

Raymond



John Vinson said:
Hi everyone!

I've got a form with a subform in it.
In this subform I want to see the 4 records with the most recent date.

I'm using this SQL-statement:
SELECT [tblControle].[ControleId], [tblControle].[Hijsmateriaalnummer],
[tblControle].[ControleDate] FROM tblControle ORDER BY
[tblControle].[ControleDate] DESC, LIMIT 0,4;

but this doesn't seem to work...

What is the right way to let Access know what I want to see :p ?
Click to expand...

I can't quite tell WHAT you want to see! I'm not familiar with the
syntax LIMIT 0,4 - what is it intended to accomplish?

John W. Vinson[MVP]
Click to expand...
 
Back
Top