Senin, 06 Mei 2013

[MS_AccessPros] Beginner's Query Question- Help

 

Good afternoon.
I am stumped at trying to find out how to build a query that will tell me how many cases (table 1) with a signed contract (Table 1) from a particular zip code (table 2) were open at any point during a timeframe (ie. Jan1-Jan31).
Open and closed dates are in Table 1
Date contract was signed is in Table 1
My biggest confusion lies with the fact that I don't want to know that they signed a contract during the time frame, but rather that they had a signed contract during the timeframe.
Thank you.

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
MARKETPLACE


.

__,_._,___

Tidak ada komentar:

Posting Komentar