troubleshooting Question

Can A Search Box On An Access Form Search Two Separate Tables On An Access Form At Once?

Avatar of ES-Components
ES-ComponentsFlag for United States of America asked on
3 Comments1 Solution25 ViewsLast Modified:
I have two separate queries on an Access form. A Company Name Query and a Contact Query.
I need one Search box that would Search both queries for the Company Name and then display
the results in both queries. See below for an example of what the queries look like.

Company Name      # Quotes                        Company Name         Contact      Last Call         Notes
BAE Systems           20                                    BAE Systems Inc.    John Henry    4/1/20        Please quote
Synqor                      35                                    Synqor Company     Paul Smith     4/8/20       Product Talk
                                                                           BAE Company          Roger Adam  4/2/20       Specs

 The challenge is that there is NO exact match between any fields in these two queries. Ultimately,
I would like to search the Company Name field as a "Like" statement and in the above example if
the user entered BAE the queries would display separately as shown below:

Company Name      # Quotes                        Company Name         Contact      Last Call         Notes
BAE Systems           20                                   BAE Systems Inc.   John Henry   4/1/20      Please Quote
                                                                          BAE Company        Roger Adam 4/2/20      Specs

If this can be done, I need to know what SQL "Contains' or "Like" statement is as I am
not an Access Programmer.

Thank you in advance for any help!!

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros