D
David Sullivan
I am wanting to create a form where i shall manually put
in the parameters of various fields i.e. like a filter
But I only want it to filter the records on data that I
input. If the data is Null then do not search, I am not
sure of the syntax I need to use for the query to search
on for each field.
Can the criteria be given syntax to say if data is input
use it, but still continue to the next field to check for
data input, if no data is input then continue to the next
field until last field has been checked
in the parameters of various fields i.e. like a filter
But I only want it to filter the records on data that I
input. If the data is Null then do not search, I am not
sure of the syntax I need to use for the query to search
on for each field.
Can the criteria be given syntax to say if data is input
use it, but still continue to the next field to check for
data input, if no data is input then continue to the next
field until last field has been checked