Hello Christine...
My first idea would be that the query is SUPPOSED to return 580 records but is incorrect and therefore returns way less...
The second would be that the table is filled incorrectly...
So to find out what's what I would first:
- test the query in the query editor to verify that it DOES return 580 records
- if it's not the case, correct the query, if it's the case, try to display it in something else than the table, for testing...
This should give you enough information to find out what is causing the problem
best regards