specific query

  • Thread starter Thread starter sarah kiernan
  • Start date Start date
S

sarah kiernan

hi i have created a database for call logging porpose
within our company , there are several information
headings one is date opened (when the call was recived)
and one called date closed (when the call has been
resolved). I have created a query to only show the calls
that are Closed (this Works) but i cant create the query
for calls that are open ONLY, as when i run any of these
queries i still see the calls that are closed can anyone
help
 
Maybe in your open calls qry put criteria on the date closed field of Is Null, this way it should only return records where there is no date closed and therefore return only 'open' call

Hope this help

Shawna
 
Back
Top