Now, I created a form that has fields to limit the date range or provider number included in the report. I wanted to include these variables in my query as well. We can call these unbound fields:
My question: How do I do this?!?! The criteria will apply differently to both tables... I have no relationsips defined, either...
ANY pointers would be greatly appreciated, I am a pretty quick study!
Base your form on a select query. If you want the form to show data from both tables then just add both the tables to the query. In the field that you wish to limit the data by, just use something like this in the criteria: Like [Enter project number] & "*". The asterisk in the quotations (wildcard character) means that it will return all results that contain the user defined criteria as well as anything else after, i.e. If the user entered '123' as the criteria, the query would return results containing 123, 1234, 1235, 123hte, etc. Sorry if this reply seems a little simpleton, I just prefer to explain everything as simply as possible because I don't know your experience level with Access.