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
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
__._,_.___
Posted by: Jim Wagner <luvmymelody@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar