"The results are displayed in a datasheet now, which is ok."
In other words, the query returns a datasheet view of the results.
I thought that answered the question. I also wanted to explain what I wanted to achieve, the more details the better.
I'm still learning all this on my own with...
Duane,
A little history:
I have a drawings table and I want users to be able to search that table based on one or more criterias. I created a form with all the fields contained in that table and a search button that calls the query. The query has the criteria fields set to get data from the...
All right,
additionnal question:
There's about 10 fields the user can search on, the problem is that if a field is empty, there are no records returned. How can I have the query return records even if a field is blank ?
Thanks
Pierre
Hello,
I'm building a query based on user input from a form, the problem is that the user has to input the exact query term to retrieve information.
It looks like this in the criteria section of my query: [Forms]![drawing20041209]![Drawing Number]
Is there a way to use the 'like' statement in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.