Trouble with DSUM as a Query expression

S

Spidey3721

Have table called [ProjCosts] ([ProjectID]; [Cost])

Have Query that calls from this table, along with a few others([ProjInfo] to
pull address with [ProjectID] relationship, etc... )

Trying to add a calculated field to this Query (Which I am using as a Report
recordsoucre) that calculates the total [Cost] associated with the current
record's [ProjectID].

So I want each record in the dynaset to show a Project ID, a particular
cost, and then the total project cost....

I have added a field in the query design view, called DSUMTest

DSUMTest: DSUM("[Cost]","[ProjCosts]","[ProjectID]= " &
ProjCosts.ProjectID )

I am getting a blank field when I preview the query.

What could I be doing wrong. I sense that there are some complications with
me trying to use the current record's [ProjectID] value from within the
record itself ? ? ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

prevent dupes if 6
prevent dupes if 1
prevend dupes if 4
Relationship with a Primary Key? 4
Problems with Multiple Rows in Query for Report 1
query help 1
Crosstab Query Input Failure 2
How to add a sum text box to a form 5

Top