Automatically Updated Dates and Queries

[spudracer]

I can't remember if I've asked this before, and my mind is getting old.

I've got a query, in which I need to track reports. What I want to do, is populate a field where the date of the last report is projected out a year. Easy enough, right?

I've got that set up, and it works the way it's intended, but the problem I'm running into is that the query is returning results on reports that are in work, but not their current data. The query will display the results of the last report completed, because there's nothing showing that the report for the current year is being worked on, even though I have the query set to only show those that haven't been received.

The two fields I'm calculating the results from are "RptStatus" and "NextReport"

RptStatus is

Is Null

NextReport is using the criteria of

Between Date() And DateAdd("m",-1,Date())

The reason RptStatus is null, is because I'm looking for reports I haven't received yet, that are coming up as being due.

NextReport relies on the date the report was last performed on +365.

Any thoughts? I'm on Access 2010.

 

[Guus2005]

i don't understand your question.

can you give me a tablename and some fields, a query that doesn't produce the result you're after and an explanation why

...
NextReport is using the criteria of

Between Date() And DateAdd("m",-1,Date())

does not match

...
NextReport relies on the date the report was last performed on +365.

i am a little puzzled about your question.

 

[spudracer]

Ok, I think I figured it out. Disregard the original question. My new question is how to store the information updated in a query, to a table.

The table is tblReports and the query is qryReports. The field is NextReport.