I am running a very basic query for New York based clients and their addresses on Paradox 9, Windows XP. The answer table shows a list of results but I've found that it does not report the twenty or so most recent entries in the database even though they are listed as New York. The entries do show up when I do a Find/Locate on the table itself but never in the query. I've tried deleting the entries and re-entering them, but that didn't help.
I'm fairly new to using this program...thanks in advance!
There are two probable answers. A corrupted table, or the query and data are not matching up. First check the table using the Table Repair Utility (under Tools), then post your query so we can have a look at the syntax.