specific query

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
 
G

Guest

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
 

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

Pass a parameter to nested query 6
QRY for Everything open in a certain time period 1
Date Diff in a query or form 3
Open and close query 4
Select only records past a key date 10
New to queries 3
Crosstab Query 1
Query question 1

Top