Counting the financial year data

[venu_resoju]

hi all of you...

I am bringing one more problem here........please advise me.

I have created one Query based on a table named Payroll which is having fields are...

1. EmpID
2. EmpName
3. Sum of No of Days Worked
4. Sum of Working Days
5. Wage Rate
6. Sum of Basic
7. PayPeriod (data like Jan-2011, Feb-2011, Mar-2011)

I am using WHERE condition on PayPeriod is BETWEEN forms!form1!fdate And forms!form1!tdate. it is working but not correct.

I have tried like >=forms!form1!fdate and <=forms!form1!tdate. but it is showing emty

Here (fdate and tdate)'s are data fill like Apr-2010 and Mar-2011 or Apr-2008 and Mar-2009 on Form1

Please someone help...thanks in advance/-......

 

[DCrake]

Dates formatted as April - 2011 etc are treated as text strings not dates. That is why your filters are not working.

 

[venu_resoju]

OK thank you Mr DCrake...

but what can I do? is there any other formulas...please tell me...

 

[DCrake]

Create another set of fields that are formatted yyyymm and filter on them