J
Jasper Recto
I have a query that grabs the date from a form and uses that as a filter
criteria.
I would also like to use a another field from that form, such as the vendor
name, to use as a filter criteria.
However, If the user does not enter in a vendor name than I would like it to
run the query for all vendors. If the user enters in the vendor, I want it
just for that vendor.
Is it possible to setup a query so that if a field is blank, it will
continue with the query. If it is not blank, than it will use that value
for the query.
Any ideas?
Thanks,
Jasper
criteria.
I would also like to use a another field from that form, such as the vendor
name, to use as a filter criteria.
However, If the user does not enter in a vendor name than I would like it to
run the query for all vendors. If the user enters in the vendor, I want it
just for that vendor.
Is it possible to setup a query so that if a field is blank, it will
continue with the query. If it is not blank, than it will use that value
for the query.
Any ideas?
Thanks,
Jasper