Query look up

G

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
 
J

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]
 
G

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
 
L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

look up date 1
lookup by date? 1
looking up rejected items 11
look up rejected items 1
Mailmerge specific query results into Word 0
lookup between dates 8
Multiple actions with one form 4
Merry Christmas! 8

Top