DAvg with multiple criteria help

[mphynson44]

Hi I am having and issue with DAvg involving multiple criteria. I am using the expression below and it returns the average of everything, I just want it to average the criteria below. Any help would be greatly appreciated.

Round(DAvg("turnaround","Ad Closed","[request reason]='Existing Client'" And "[request reason]='ANNUAL REVIEW'" And "[request reason]='THREE YEAR REVIEW'" And "[request reason]='UPDATE REVIEW'"),1)

[June7]

Your parameters are literal text so the WHERE CONDITION argument should be one long criteria string. You have too many quote marks. Include the AND operators within the string and have quote marks at only begin and end of the entire criteria string.

[mphynson44]

Your parameters are literal text so the WHERE CONDITION argument should be one long criteria string. You have too many quote marks. Include the AND operators within the string and have quote marks at only begin and end of the entire criteria string.

Makes sense, that helped a little bit but when I run it now I only get the average for the first criteria Existing Client. See below for what I ran this time.

Existing Client Turnaround: Round(DAvg("turnaround","Ad Closed","[request reason]='Existing Client' And 'ANNUAL REVIEW' And 'THREE YEAR REVIEW' And 'UPDATE REVIEW'"),1)

[June7]

You have to repeat the field name for each parameter. Wait, AND won't work, try OR instead.

Go back to your original structure, remove the extra quote marks, replace AND with OR.

[mphynson44]

You have to repeat the field name for each parameter. Wait, AND won't work, try OR instead.

Go back to your original structure, remove the extra quote marks, replace AND with OR.

Worked like a charm, Thank you for the help!

just for anyone who find this on future searches this is it:

Round(DAvg("turnaround","Ad Closed","[request reason]='Existing Client' OR [request reason]='ANNUAL REVIEW' OR [request reason]='THREE YEAR REVIEW' OR [request reason]='UPDATE REVIEW'"),1)