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

Senin, 14 Juli 2014

Re: [MS_AccessPros] Using DSUM in an expression

And assuming ApplicationID is a number, you'll get an Error if there is no value in ApplicationID in the current record. Consider wrapping an IIf around it to test IsNull([ApplicationID]) and call the Dlookup only if there's a value.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jul 14, 2014, at 6: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

__._,_.___

Posted by: John Viescas <johnv@msn.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

Visit Your Group