Vis 1. record i SQL=SELECT...

hasnt this question been up before?

If the SQL by default retunrs all records, then to only show one of those records you use the Filter property. This is the same as the WHERE part of the SQL

Hej og tak for svaret

Din løsning har jeg prøvet men kræver en del ekstra koder så jeg havde håbet på der fandes en smartere metod

"Din løsning har jeg prøvet men kræver en del ekstra koder så jeg havde håbet på der fandes en smartere metod"

What is "Smartere"??
Somehow you have to tell access to show only one record instead of all of them.

And what ever method you choose is going to require some work one way or another. You cant expect Access to be able to read your mind and just show one of the records.

"Din løsning har jeg prøvet men kræver en del ekstra koder .."

I dont think setting the Filter property requires much code at all.

Me.Filter = "SomeField = 1234"
Me.FilterOn = True

Alle poster:
SELECT DinTabel.*
FROM DinTabel
ORDER BY Et Felt;

Første post:
SELECT TOP 1 DinTabel.*
FROM DinTabel
ORDER BY Et Felt;

#4
Thats going to give (possibly) only one record, but its always going to be the first, and I'd be very surprised if thats whats wanted.

Maybe - and maybe not  ;O)

"Jeg har brug for at vis både alle record samt den 1. record alene".
Hvis posterne er sorteret korrekt, vil Top 1 vel give "den 1. record".

Det blev en løsning med en kombination af:

Me.Filter
og
med TOP 1

TOP 1 var ny for mig. 1000 tak for hjælpen

Hvis posterne er sorteret korrekt...

which still requires a change to teh SQL to sort after a specific record to get the first. So I may as well use WHERE....

But then its not me who wanted the solution, so ....

And I'll just mention again. TOP 1 does NOT necessarily return only one record