db query

T

Ted Ljong

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top