'=Abs(Sum([Field=Criteria]))' - Can you add more criteria?

[Stevehewitt]

Hi Guys,

Just wondering,

I have a field on a report which needs to show a total of all of the records that have a -1 in the FullApps field but only for records where the CompletedDate is the same as the date entered into a text box on a form.

Is this possible?

E.G. =Abs(Sum(([FullApps]=-1) AND ([CompletedDate] = [Forms]![frmReportDateSpecific]!{txtDate])))

Obviously the above doesn't work, but I'm wondering if someone knows what I'm trying to do and give me a push in the right direction?!

Hope this makes some sense!

Cheers,

Steve.

"They have the internet on computers now!" - Homer Simpson

 

[mp9]

Untested but worth a go:

=Sum(([FullApps]=-1) * ([CompletedDate] = [Forms]![frmReportDateSpecific]![txtDate]))

http://www22.brinkster.com/accessory/

 

[Stevehewitt]

Hi again mp9,

I've ended up doing it the longer way round of a sub report and using two different master reports... whoo!

Thanks for you help anyway.

Cheers,



Steve.

"They have the internet on computers now!" - Homer Simpson

 

[RoyVidar]

Your syntax works on my setup (just change the one "{" to "["), but I'm just wondering, would there be a time fraction in addition to the date in either the report field or the form control? If so, wrap them both in the Int() function.

Roy-Vidar

 

[Stevehewitt]

Thanks Roy,

Just realised that it was a sodding typo on my part!!! I've spent ages splitting the reports and creating new queries etc....!!!!

Just FYI it is a date only field so there is no time to use - wish I had the fosight to have done it - would have saved me a lot of hassle.

Thanks for you help,

Cheers,




Steve.

"They have the internet on computers now!" - Homer Simpson