23. august 2010 - 14:41
Der er
4 kommentarer og 1 løsning
Kriterier i en krydstabulering
Hej Jeg har oprettet en krydstabuleringsforespørgsel. Jeg skal bruge et kriterie, som normalt virker i en forespørgsel: >=[From Date (dd-mm-åååå)] And <=[To Date (dd-mm-åååå)] Normalt ville dette begrænse min søgning inden for 2 datoer. Men det virker ikke i en krydstabulering foresprøgsel. Er der nogen der kan, den rigtige formel ? MVH Tony
Annonceindlæg fra FPT Software
24. august 2010 - 08:41
#2
Hi Terry Yes, i have tried this, but the report will not accept this. First i have made a normal Qeury, with all the fiels i nedd, and comming up aksing for date. After that made a krydstaubleringsforespørgsel, using the first query. When I create the report, it cannot see fieds in the krydstabulering. Regards Tony
24. august 2010 - 09:33
#4
Hi Terry I found out, I had made a mistake, so it is working now. Tks. Terry Can I give you points ? Regards Tony