Yes, it's possible.
Look at "DemoCrostabQryA2000.mdb (attachment, zip).
Look at Table1, Query1 (column 4), Query1Crostab, Form1 (Vba), Module1.
Open Form1 and click on command button.
Look at tblNewOne.
1) I dont know what you want. This code is from "Form1" not from query.
If you want it, you have to write a new code, depending on what you want to do.
Yo have to learn how to make a program.
2) Yes you can do it.
Look at Demo (a new one). In Form1 I add 2 fields (DateFrom and DateTo).
Look at "Query1", (column 5).
Look at Form1 "Default value" properties in the fields (DateFrom and DateTo).
Open Form1 and try.
Use your date format (short date, 01/06/2011 and s.o.)
Thanks again ... am slowly working my way through it when can spare some time, so slow progress. Maybe even learning a little about programming in the process - last time I did much programming was around 1993, so a little has changed since then!