Hi
Sorry I sent this by misstake several times on the wrong date

Im using FP 2K and Acess2000 and I have this db query

SELECT * FROM medlemsregister WHERE (fnamn LIKE '::fnamn::%') ORDER BY enamn
ASC,fnamn ASC

It works ok when i wright any letter in the formfield but when I leave it
empty and hit enter the entire db is listed. I don´t want anything to be
listed if I don´t search for anything in that field. I hope there is someone
that can give me a clue how to wright the query.

Thanks

Ted Ljong

This makes SIX times you've reposted this question. See my answer to number
2.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Neither a follower nor a lender be.

"Ted Ljong" <(E-Mail Removed)> wrote in message
news:uF%23Cw%(E-Mail Removed)...
> Hi
> Sorry I sent this by misstake several times on the wrong date
>
> Im using FP 2K and Acess2000 and I have this db query
>
> SELECT * FROM medlemsregister WHERE (fnamn LIKE '::fnamn::%') ORDER BY
enamn
> ASC,fnamn ASC
>
> It works ok when i wright any letter in the formfield but when I leave it
> empty and hit enter the entire db is listed. I don´t want anything to be
> listed if I don´t search for anything in that field. I hope there is
someone
> that can give me a clue how to wright the query.
>
> Thanks
>
> Ted Ljong
>
>
>