look up date

G

Guest

I have a query that looks up when testing was done. Once it has been tested
I don't need to check it. Is there a way to put a criteria in so it only
looks up from the last date that I looked up to the present? Thanks in
advance.

Annette
 
S

Stefan B Rusynko

Presuming the date is part of the DB structure
Add a date to your query as an AND

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I have a query that looks up when testing was done. Once it has been tested
| I don't need to check it. Is there a way to put a criteria in so it only
| looks up from the last date that I looked up to the present? Thanks in
| advance.
|
| Annette
 

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

Query look up 4
lookup by date? 1
Excel Colour code dates 1
Please help! date showing as 1900/01/00 2
looking up rejected items 11
look up rejected items 1
Access Employee testing checklist 0
Lost days in Powerpoint 0

Top