Query Parameters (1 Viewer)

[pickslides]

In the following code I have a parameter 'RegionPrefix' that filters my data by the first 2 characters of the 'Queue' field.

How do I populate the 'RegionPrefix' parameter so it returns all of my data? Currently if I leave it blank it returns nothing.

PARAMETERS RegionPrefix Text ( 255 );
TRANSFORM Format(Avg([Abandonment Rate]),"Percent") AS ABAN
SELECT [Call Summary Table].Year, [Call Summary Table].Month
FROM [Call Summary Table]
WHERE (((Mid([Queue],1,2))=[RegionPrefix]))
GROUP BY [Call Summary Table].Year, [Call Summary Table].Month
PIVOT [Call Summary Table].Queue;

 

[Uncle Gizmo]

How do you call the query?

 

[pickslides]

By double clicking the query name from the list or using the Datasheet View button.

 

[MarkK]

You could try changing this . . .

WHERE (((Mid([Queue],1,2))=[RegionPrefix]))

. . . to this . . .

WHERE IIf(Len([RegionPrefix]), Mid([Queue],1,2)=[RegionPrefix], -1)

I'm curious if that would work.