Auto search form for TRANSFORM query

rbuser

Hi!

Here s query:

TRANSFORM Count(UMVGL.Id) AS CountOfSifra
SELECT UMVGL.Datum, Count(UMVGL.Id) AS [Total Of Sifra]
FROM Ispitivac INNER JOIN (UMVGL INNER JOIN UMV ON UMVGL.Sifra = UMV.Sifra)
ON Ispitivac.Sifra =
UMV.Ispitivac
WHERE UMVGL.Prefix='1' AND
UMVGL.Datum Between #01/01/2001# And #01/31/2001#
GROUP BY UMVGL.Datum
PIVOT UMV.Ispitivac;


How to add Auto search criteria manually for a query like that.....

Regards,

Benjamin

P.S.
Sorry if this is repeted post but eventhought I think I saw something like
that...now cannot find it!
;-)

The difference between theory and practice is that in theory there is no
difference between theory and practice, but in practice there is....

rbuser

Sorry wrong group!