Greetings fellow Minnesotan,
Use this logic in the criteria:WHERE [OpenDate] <= #1/31/2013# AND [CloseDate]>=#1/1/2013#
This assumes there are always open and close dates.
Duane Hookom MVPMS Access
> To: MS_Access_Professionals@yahoogroups.com
> From: Sheryl.Jones@state.mn.us
> Date: Mon, 6 May 2013 18:29:17 +0000
> Subject: [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]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[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 (2) |
Tidak ada komentar:
Posting Komentar