Parameter Question (1 Viewer)

glpkid

Registered User.
Local time
Today, 09:06
Joined
Apr 3, 2006
Messages
14
I have a form and a Query based on a form. I have 3 different columns in my query. One is City, second is citycode, and the third is Cell Phone Provider. Now each city has a citycode and vice versa, however, not each city has a cell phone provider. Which means there are some boxes that are blank. My problem is that when I search for all cities that begin with say, "A", it only brings up the cities that have a value for the cell phone provider, and the ones that are blank don't come up. Could someone help me out?
 

glpkid

Registered User.
Local time
Today, 09:06
Joined
Apr 3, 2006
Messages
14
This is what i have for all 3 columns, of course the control name is different for each column.

Like Forms!QBF_Form!City & "*" Or
Forms!QBF_Form!City Is Null
 

Users who are viewing this thread

Top Bottom