Hello everyone.
Situtation: I created a union query selecting data from 4 different tables. I set up a form to display the information and run a search for data using query by form. This works just fine. However, 3 of the tables have a field for organization name and one doesn't. The one that doesn't has and OrgID field that links to another table Activities by OrgID. So, in order to get the name of the organization added to the table I used in my union query, I created a separate select query to add the orgranization name. I tried replacing the 4th table in the union query with the select query. If I just run the union query, not using the form, everything looks great. Then I added search criteria to the union query in the query design mode and the query works fine. However, when I try to search by form, I don't get any results.
I hope I explained everything well.
Is there a way to get the results that I need using query by form or is that just not possible?
Karen
Posted by: k2j1203@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar