Hi,
I have created a search query with a number of criteria.
The thing is I've imported alot of data into my DB and alot of fields are empty in its record. These records aren't shown in the search results. So I'd like to adjust my query so that every record is displayed when no criteria has been entered in the search form.
This is my query so far:
Some help please .... ?!
Thanx
[This message has been edited by Wallie (edited 04-18-2002).]
I have created a search query with a number of criteria.
The thing is I've imported alot of data into my DB and alot of fields are empty in its record. These records aren't shown in the search results. So I'd like to adjust my query so that every record is displayed when no criteria has been entered in the search form.
This is my query so far:
Code:
SELECT [tblBedrijven].[Id],[tblBedrijven].[bedrijfsnaam]
FROM tblBedrijven
WHERE ((([tblBedrijven].[WerknemerId])=IIf(IsNull([Forms]![bedrijfInvoeren]![WerknemerId]),[WerknemerId],[Forms]![bedrijfInvoeren]![WerknemerId])) And
(([tblBedrijven].[provincieID])=IIf(IsNull([Forms]![bedrijfInvoeren]![provincieId]),[provincieId],[Forms]![bedrijfInvoeren]![provincieId])) And
(([tblBedrijven].[brancheID])=IIf(IsNull([Forms]![bedrijfInvoeren]!brancheId),[brancheId],[Forms]![bedrijfInvoeren]!brancheId)) And
(([tblBedrijven].[soortBedrijfID])=IIf(IsNull([Forms]![bedrijfInvoeren]![soortBedrijfID]),[soortBedrijfID],[Forms]![bedrijfInvoeren]![soortBedrijfID])))
ORDER BY [tblBedrijven].[bedrijfsnaam];Some help please .... ?!
Thanx
[This message has been edited by Wallie (edited 04-18-2002).]
