Relationships between two queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created three different tables with common field I would like to do a query
that merge common fields and uncommon fields into one table the only problems
is that some on field have data type memo, I am getting a messege that the
query cann't be created because of these types of field
Any suggestions?
 
When you say "merge into one table" do you mean you actually want to create
a new table? Why?

A query can be used just like a table in your forms, reports, or even other
queries. Simply build your query to pull the data you want, then use that
query as the source for your forms or reports.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query field size quandry 2
Make Table Query Truncating Memo Field at 255 Characters 2
Memo fields not displaying in query 4
Query set-up with two tables 9
Query to group similar number combinations? 4
Query with common fields to all records 6
Can you merge a "Count" Crosstab with a "Money Sum" Crosstab? 7
Capturing data from two tables... 5

Back
Top