problem with a query

Question

Customerno Name. Adress City
1 X. Y. Z.
2. Q. W. E
3.
4. R. T. Y

There are more customers in the table

I use select * ... and where customerno in (‘1’,’2’,’3’,’4’) but in the result is only shown results from 1, 2 and 4.

What can I do to include the no. 3 even the result for this are nothing

Answer 1

Ahh, thanks I’ll try that. I am a bit new to this :-) I get back when I tried it.

Answer 2

Guess that there was a problem with the query, I splitted it in two and used the vlookup function in Excel, and thrn I got the expected result. Thanks again for the answer.