ACCESS FEED: RE: [MS_AccessPros] Using DSUM in an expression

Senin, 14 Juli 2014

RE: [MS_AccessPros] Using DSUM in an expression

It looks like your DSUM has a space in [Income Amount], while the querydef does not.

Also, I would refer to the (assuming there is a ) bound Application ID text box control explicitly, so, try this:

=DSum("[IncomeAmount]","HouseholdTotalIncome","[ApplicationID]=" & me.ApplicationID)

Steve

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 14 Jul 2014 16:02:18 -0700
Subject: Re: [MS_AccessPros] Using DSUM in an expression

Tried it both ways and neither one worked.

With Warm Regards,

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265 Ext. 130

Fax (605)964-1070

alorenzini@crhanetwork.org

"Only those who will risk going too far can possibly find out how far one can go."

On Monday, July 14, 2014 5:30 PM, "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Art,

I thought the last quote should be at the end not after the = sign? I could be wrong

=DSum("[Income Amount]","HouseholdTotalIncome","[ApplicationID]= & [ApplicationID]")

Jim Wagner

On Monday, July 14, 2014 3:23 PM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Data types of significant fields please?

Duane Hookom

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 14 Jul 2014 14:59:18 -0700
Subject: [MS_AccessPros] Using DSUM in an expression

I am trying to use DSUM as the record source of a unbound text field. The statement is as follows:

=DSum("[Income Amount]","HouseholdTotalIncome","[ApplicationID]=" & [ApplicationID])

The query HouseHoldTotalIncome is defined as:

SELECT tblHouseholdIncome.IncomeID, tblHouseholdIncome.HouseholdID, tblHouseholdIncome.IncomeTypeID, tblHouseholdIncome.IncomeAmount, tblHousehold.ApplicationID, tlkpIncomeType.IncomeTypeName, tlkpPayFrequencyType.PayFrequencyTypeName, IncomeAmount * tlkpPayFrequencyType.FreqMultiplier AS [Annual Income], tblHouseholdIncome.PayFrequencyTypeID
FROM ((tblHouseholdIncome INNER JOIN tblHousehold ON tblHouseholdIncome.HouseholdID = tblHousehold.HouseholdID) LEFT JOIN tlkpIncomeType ON tblHouseholdIncome.IncomeTypeID = tlkpIncomeType.IncomeTypeID) LEFT JOIN tlkpPayFrequencyType ON tblHouseholdIncome.PayFrequencyTypeID = tlkpPayFrequencyType.PayFrequencyTypeID;

But I keep receiving a @Error when I run it. Any ideas?

Thank you,

Arthur Lorenzini
Sioux Falls, SD