Query in a loop

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

Guest

If I set relationships between my tables, my query does not read from the
tables. If I delete the relationships, my query starts to multiply the data
in the query.
 
Do you mean a join or a relationship?

If no data is returned it is because the values do not match
 
If there are joins in the query design view between the tables, no data are
retrieved. If I delete the joins, it retrieves the data but goes into a loop
and stops at around 15000 entries in the query.
 
Correct, because no matching records are found between the 2 tables being
joined.
 
thanx John, I'll go back and try again and if I need help, I will call again.
I am a newbee with this, only trying.
 
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

Delete Query: Could not delete from specified tables 0
Queries; Make Ready 1
Repeating records in Query 20
Delete Query Cannot delete from specified tables 4
Access Command button to look up and copy data from a query to a table 0
Update Query 4
TOUGH QUESTION:Can a query create a relationship between two tables????? 4
Can't edit my query 2

Back
Top