search form

[m.lammerts]

HelloI am a beginner with sql.I am, however, knowledge of programeren in VBA, we have an access ADP database as frontend.en the table stand as backend on sql server.now I want make search form in which we can search registered, address, etc.I don, t how I must start this can you help me please greet M.Lammerts

[JamesB]

i'm not too good with SQL, but maybe you could do something like this:

SELECT * FROM table WHERE registered LIKE '%text%' OR address LIKE '%text%'