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 (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar