Query look up

[Guest]

Hi,

I have a query that looks up testing being done. After I review the record
I don't need to check it again. Is there a way to put a criteria in so it
looks from the last day that I checked to the present date. Any information
will be greatly appreciated. Thank you in advance.

Annette

 

[John W. Vinson]

Hi,

I have a query that looks up testing being done. After I review the record
I don't need to check it again. Is there a way to put a criteria in so it
looks from the last day that I checked to the present date. Any information
will be greatly appreciated. Thank you in advance.

Annette

Yes. You would base the Combo on a Query with a criterion selecting the
desired range of dates.

Since you haven't posted any information about the nature of the data being
displayed, or how you're recording the review date, I can't describe how to do
this - but a query would be the solution.

John W. Vinson [MVP]

 

[Guest]

Hi John,

What I'm doing is checking to make sure testing is being done on our
product. There are 4 tests that can be done. Depending on what test they
use depends on how many test fields they use, so I have to be able to see all
the test fields. Once I check them I don't have to review them but I have to
keep them if we have a problem. What I would like to do is do a query to
look up the next test records and not review what I already looked at. I
don't check this daily it is checked weekly. So my criteria is for a week.
I hope I explained everything and that it makes sense. Thanks again.

Annette

 

[Larry Daugherty]

How about adding a "DateVerified" field or something like that. When
you check things, enter the date. Now your query can return all
records where that field is empty.

HTH

 

[Guest]

Hi Larry,

Thats a great idea! Thank you so much.

Annette