Jumat, 29 Juli 2011

RE: [MS_AccessPros] Re: Query help needed

 

Sheryl-

SELECT * FROM MyTable
WHERE DatePASigned Is Not Null
And (DatePaSigned - DateOfReferral) > 60;

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of sherylj
Sent: Friday, July 29, 2011 7:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Query help needed

One more thing. There can also not be any PA's included that weren't signed.
THis has to be so simple, but I cant get it to work...

--- In MS_Access_Professionals@yahoogroups.com, "sherylj" <Sheryl.Jones@...>
wrote:
>
> I am trying to build a query and I just cant figure it out. I have two fields
that I am working with. One is called DATEOFREFERRAL and the Other is called
DATEPASIGNED. What I am trying to query is any PA's that were signed more than
60's from the date of referral. Can anyone help me out?
>

------------------------------------

Yahoo! Groups Links

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar