taylorhouse
New member
- Local time
- Today, 15:14
- Joined
- Sep 3, 2010
- Messages
- 6
Hi
I have a Report form where i can select selection criteria for a query. The form name is frmreport and the field is fldmachine. I also have a check box that enables and diasbles this field.
In the query criteria i have
"Like Forms!frmreport.fldname"
when i select the type of machine and run the report i get what i want. But the problem comes when I dont want to filter and just see all entries.
When i disable the fldmachine field i pass
"*" which equates to "Like "*"" in the query criteria and this then displays all the entries with content in the machine field but does not display the records with Null in the machine field.
If i enter in the criteria or field of the query "Is Null" then it works or if i use "Like Forms!frmreport.fldname Or Is Null" this works
But if i try and pass either "Is Null" or "Or Is Null" it seems to be seen as text and is looking for those words and not seeing it as i need
I am sure there is a way of passing this information to the query without it taking the text literally but am stuck and need your help
Thanks
Darren
I have a Report form where i can select selection criteria for a query. The form name is frmreport and the field is fldmachine. I also have a check box that enables and diasbles this field.
In the query criteria i have
"Like Forms!frmreport.fldname"
when i select the type of machine and run the report i get what i want. But the problem comes when I dont want to filter and just see all entries.
When i disable the fldmachine field i pass
"*" which equates to "Like "*"" in the query criteria and this then displays all the entries with content in the machine field but does not display the records with Null in the machine field.
If i enter in the criteria or field of the query "Is Null" then it works or if i use "Like Forms!frmreport.fldname Or Is Null" this works
But if i try and pass either "Is Null" or "Or Is Null" it seems to be seen as text and is looking for those words and not seeing it as i need
I am sure there is a way of passing this information to the query without it taking the text literally but am stuck and need your help
Thanks
Darren