ACCESS FEED: Re: [MS_AccessPros] DCount question

Selasa, 29 Juli 2014

Re: [MS_AccessPros] DCount question

So my bad but I was mistaken. I am getting too many records. I need only 7. So I realized that I need 45 days from today.

Jim Wagner

On Tuesday, July 29, 2014 10:29 AM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

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

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

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