Steve,
Thank you very much. You had the right of it. The final code looks like this.
=DSum("[Annual Income]","HouseholdTotalIncome","[ApplicationID]=" & [ApplicationID])
Works like a champ.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Only those who will risk going too far can possibly find out how far one can go."
On Monday, July 14, 2014 6:11 PM, "Steve Conklin StephenMConklin@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
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
With Warm Regards,
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
"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
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
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
__._,_.___
Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar