Senin, 06 Mei 2013

[MS_AccessPros] Re: Beginner's Query Question- Help

 

Sheryl

What you need to do is find out if the signed date was between those dates or earlier. I'm assuming once the contract is signed it doesn't expire. If it does then you need to also check that the expired date is not before the start date.

That make sense?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

--- In MS_Access_Professionals@yahoogroups.com, "Jones, Sheryl (HLB)" <Sheryl.Jones@...> wrote:
>
> 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 (3)
Recent Activity:
MARKETPLACE


.

__,_._,___

Tidak ada komentar:

Posting Komentar