Search results

Ok, I'm still not quite getting this. I've revised my queries so that they both contain the same information as the Main Table. The process works like this: Query 1 searches a secondary table --> Query 2 combines information from Query 1 to match that of the Main Table. The result is my two...

Main is an original table but the two queries are built of other tables containing different information. They all have the GCFA# in common which ties everything back to the Main table which contains phone numbers, etc.

I think I'm still stuck on the "what type fields can I use" problem. In your example you show that both queries are searching the same fields. Mine are not. I've included a screenshot that matches my current query settings as closely as I can to yours. This setting, however, returns all of the...

I can't seem to get the join properties to work correctly then. It seems that I can only get the results from one of my queries and the table and not both of the queries and the table. Again, I'm pretty new to Access and just can't seem to figure this out.

Yeah, the common fields is the ID field. The Main Table has the ID field (here is where it's unique), the People Table (used for Query 1) uses the ID field to connect the contacts with the company, and the Data Table (used for Query 2) uses the ID field to connect the statistics to the company...

Well that won't exactly do what I want it to then... Is there then some other option to get both queries so they output on the same Report?

I have three tables, a Main Information table which is physical address/phone number/company name type stuff. I have another table which is People, all my various contacts at the different locations, and a third table which is Data which contains statistical information on the different...

Taking your idea, I created a new query with my Main Information table and my two Target queries. I created a join between the ID fields of three pieces of information. If I tell the join type to show all from the table and only matches from the queries, I get all of my records when I should...

I'm the dummy in question. I'm new to Access and have a fairly simple database that I'm using to find potential customers. I am targeting them by two criteria using two different queries (both queries are looking at different fields of the same table). I want to create a combined query that...