Jim,
I think you should be subtracting (-45), not adding in the dateadd function. You will never have documents on dates later than the current date.
Glenn
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, July 29, 2014 11:47 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] DCount question
I have a form that I would like to put a dcount to show the count of records <=45 days from the current date.
I have the following expression below and I am getting the #Name? error. I have checked the names and even copied and pasted the names into the expression to make sure it is correct but continue to get the error. Maybe it is something else like syntax. Any help would be appreciated.
=DCount("[Emplid]","qry_Stipend",[Flsa Status]=DateAdd("d",+45,Date()))
Thank You
Jim Wagner
Posted by: "Glenn Lloyd" <argeedblu@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar