Help...... (1 Viewer)

[TajikBoy]

Hi Guys,

I'm getting desperate...Whatever I do, doesn't work...

Can someone pls convert below to a DSUM function for me?

SELECT tblAreas.ID, tblAreas.Project, tblAreas.Cost From tblAreas WHERE (((tblAreas.ID)=[Forms]![frmProjectContractEntry]![AreaName]) AND ((tblAreas.Project)=[Forms]![frmProjectContractEntry]![ProjectName]));

I want to assign it to an unbound text box called AreaBudget on the same form

Million thanks in advance,

 

[theDBguy]

Hi. What are you trying to Sum? If the cost, try:

=DSum("Cost","QueryName")

 

[TajikBoy]

theDBguy, you are a life saver !!!

I just wasted hours on this...... Thanks man!