Query is not Requerying?

[jrobin5881]

I have a query that runs over a membership table for a dues paying organization. The original table has 336 rows of data for the original membership. The table has Fname, Lname, Date Paid, TypePmt that I'm using in my query. My query is named "Dues Not Paid" so that I can have a report that gives me just that. Here's the issue: The query does returns me the info correctly on the first 336 rows but for some reason it will not look at the rows after for the newer members that have joined and have been added to the table. I tried using Requery Macro on the Open event for the report that I use but I got an error message. I also use the query on that report as the record source. Any ideas on how to get my query to run over the entire table? I'm sure the answer is probably staring me in the face.

 

[PHV]

Running the query from the database window still show only 336 rows ?
Double check the joins and criterias.
You may also consider repair the database.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jrobin5881]

The criteria are fine. I checked that by taking out a payment from a member included in the first 336 rows and he then showed up as not paying which is what the query is supposed to return. For some reason the query will not look at the newer records past the original 336 rows and include the results in the dataset. In other words for some reason the query will not look at any new member record added to the membership table

 

[PHV]

No null value in the new rows for field with criteria ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jrobin5881]

In the criteria field I have "Is Null" in order to return the rows with no payment