Problems with my query

[Jan22]

So i have made a query witch filters the text you type in your textbox on a form. This is working great, but then this morning I had some records that contain some blank fields. My query does not show those records even if they contain the same text that I would type in my search form. I've searched the internet for answers and only found that access has problems with blank fields. But can I fix this problem? This is my expression in my query of one column:



Like [Forms]![searchform]![Qprojectomschrijving] & "*"

Could somebody help me with this?

[akjandu]

I had a similar problem in the past. Blanks fields (containing null value) are creating problem. Simply update the blank fields to ZLS (Zero length string). Zero length string is a string with no characters in it for example, "". You can use update query to do this.

[Jan22]

And how do I do that?

[Jan22]

I can't change the fields to zero length because i've got another form that adds excel sheets with sometimes fields with no value into the database. If i change it i can't add any excel files.

anyone?

[Jan22]

AWL LaserLasParameters2.zip

uploaded file.

[akjandu]

can you please name the forms and tables that you are talking about?

[akjandu]

So i have changed the "like" expression a little in the query and I have also updated the search fields of table "data" to ZLS.

[Jan22]

Thnx! this was working before i start copying excel sheets into my database. After i copied new data into my database it could again not be found!
I think it has something to do with my autonumbres (wich are my Key). When i copie my files i get an error. Null-value can't get into my autonumber field

Could somebody help me?