outsourceoncall
Technical User
Objective: See a list (in tabular form view) of filtered record.
Method: Using a form that has the following fields that you may filter for: LastName, FirstName, Branch, City, State, and Zip. I have a button that opens the desired tabular form which is bound to query that has criteria points to the form values.....
Use Example: User wants to see all people named Elvis is zip code 123456.
Problem: In underlying query what do I do with the null values? This is one of the criteria expression I am using on the FirstName Fieild for instance and using similar expressions on the other Form Fields but I am not getting the desired results....I am not getting ANY records.
IIf([forms].[EmployeeChooser].[First] Is Null,[FirstName_Employees],[forms].[EmployeeChooser].[First])
I am not a programmer...please offer access tips...I can copy code if I must, but if I can use queries that is prefered.
I have successfully pulled this off with just allowing one filter permitted on the form, but I cant get it to show any records when I start asking for more than one query criteria.
Method: Using a form that has the following fields that you may filter for: LastName, FirstName, Branch, City, State, and Zip. I have a button that opens the desired tabular form which is bound to query that has criteria points to the form values.....
Use Example: User wants to see all people named Elvis is zip code 123456.
Problem: In underlying query what do I do with the null values? This is one of the criteria expression I am using on the FirstName Fieild for instance and using similar expressions on the other Form Fields but I am not getting the desired results....I am not getting ANY records.
IIf([forms].[EmployeeChooser].[First] Is Null,[FirstName_Employees],[forms].[EmployeeChooser].[First])
I am not a programmer...please offer access tips...I can copy code if I must, but if I can use queries that is prefered.
I have successfully pulled this off with just allowing one filter permitted on the form, but I cant get it to show any records when I start asking for more than one query criteria.
