Jim,
Did any of the suggestions work?
Duane
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 29 Jul 2014 10:28:15 -0700
Subject: Re: [MS_AccessPros] DCount question
Did any of the suggestions work?
Duane
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 29 Jul 2014 10:28:15 -0700
Subject: Re: [MS_AccessPros] DCount question
Duane,
I am counting from a different query not associated with the form
Jim Wagner
On Tuesday, July 29, 2014 10:26 AM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
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
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
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 (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar