I have query and I want to just pull records from a certain month. I want to run the query once a month and have the user select the month and year from the combo box in the parameter (the month that just ended usually) Does anyone know how to do this without going into design view and using hte between date way.
before this, i'm using this query to pick data from date between ? and ? using date picker.
==> WHERE Tdata.date BETWEEN ? AND ?. ? represent datepicker1.value and datepicker2.value
SELECT TUnit.[cs-username]
FROM TUnit LEFT JOIN [SELECT * FROM Tdata WHERE Tdata.date BETWEEN ? AND ?]. AS MyTempTbl ON TUnit.[cs-username] = MyTempTbl.[cs-username]
WHERE (((MyTempTbl.[cs-username]) Is Null))
ORDER BY Tunit.[cs-username];
so how can i catch all data for the whole month?
I'm Keep Studying.... please show the way...
Not Good in English
before this, i'm using this query to pick data from date between ? and ? using date picker.
==> WHERE Tdata.date BETWEEN ? AND ?. ? represent datepicker1.value and datepicker2.value
SELECT TUnit.[cs-username]
FROM TUnit LEFT JOIN [SELECT * FROM Tdata WHERE Tdata.date BETWEEN ? AND ?]. AS MyTempTbl ON TUnit.[cs-username] = MyTempTbl.[cs-username]
WHERE (((MyTempTbl.[cs-username]) Is Null))
ORDER BY Tunit.[cs-username];
so how can i catch all data for the whole month?
I'm Keep Studying.... please show the way...
Not Good in English