limitations on number of records

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

Guest

I made a query from two tables in the same database. One table had 56 records. the other table had 78 records. The query would ony show 108 records. repaetring the set up and run did not help....Is there a limit on the number of records in a query???

ps--office XP
 
Share your SQL and possibly your primary key fields. There is virtually no
limit to the number or records in a query or table.

--
Duane Hookom
MS Access MVP


phat 928 said:
I made a query from two tables in the same database. One table had 56
Click to expand...
records. the other table had 78 records. The query would ony show 108
records. repaetring the set up and run did not help....Is there a limit on
the number of records in a query???
 
Dear Phat:

I'm guessing you may need to change a JOIN between the tables.

In the design view, is there a line between the two tables? If so,
right click on it and open its properties. Pay attention to the radio
buttons marking the 3 choices regarding the way the tables are joined
in the query.

Just a guess at what might be behind your situation.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top