I want to do the following but I don't know how to make a query for it.

SELECT Costumer.Name, Costumer.ID
FROM Costumer
WHERE Costumer.Name ='starts with JAN'
I want to select all the costumers with the name started with JAN, like JANNSSEN, JANSSEN ect.

How can I do that with a query, or mayby Visual Basic Code

The following should do the trick:


SELECT Costumer.Name, Costumer.ID
FROM Costumer
WHERE Costumer.Name Like 'Jan*'


I haven't tested, but it should be OK.

Cheers,
SteveA http://www.access-programmers.co.uk/ubb/smile.gif

Thanx,
The code works!

Greetz