Selasa, 29 Juli 2014

[MS_AccessPros] Re: DCount question

 

Jim


You never use a plus sign in DateAdd. But as Glenn said you want it less than or eqaul to so it should be:
=DCount("[Emplid]","qry_Stipend",[Flsa Status]<=DateAdd("d",-45,Date()))

Bill Mosca

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Posting Komentar