Jim,
Are you counting records displayed in the current form or from a totally different query?
If a different query, try:
=DCount("[Emplid]","qry_Stipend","[Flsa Status]<=45+Date()")
If the records are in the current form, try this expression that should be more efficient:
=Sum(Abs([Flsa Status]<=45+Date()))
Duane Hookom MVP
MS Access
From: MS_Access_Professionals@yahoogroups.com
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
Are you counting records displayed in the current form or from a totally different query?
If a different query, try:
=DCount("[Emplid]","qry_Stipend","[Flsa Status]<=45+Date()")
If the records are in the current form, try this expression that should be more efficient:
=Sum(Abs([Flsa Status]<=45+Date()))
Duane Hookom MVP
MS Access
From: MS_Access_Professionals@yahoogroups.com
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: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar