R
ReidarT
I have a table with Counties and Cities
I use a form to select the appropriate data.
Table
ID City County
23 Oslo Oslo
46 Oslo
53 Bergen Sogn og Fjordane
67 Trondheim Sør-Trøndelag
87 Trondheim
97 Bergen Sogn og Fjordane
112 Bergen
In the query I use
City County
tblTable tblTable
Like(forms!form!City) Like(forms!Form!County)
The problem is that I only get records from those who have a value
If I select Oslo as city and * as County I only get 1 record, I should have
had 2 records.
reidarT
I use a form to select the appropriate data.
Table
ID City County
23 Oslo Oslo
46 Oslo
53 Bergen Sogn og Fjordane
67 Trondheim Sør-Trøndelag
87 Trondheim
97 Bergen Sogn og Fjordane
112 Bergen
In the query I use
City County
tblTable tblTable
Like(forms!form!City) Like(forms!Form!County)
The problem is that I only get records from those who have a value
If I select Oslo as city and * as County I only get 1 record, I should have
had 2 records.
reidarT