venu_resoju
Registered User.
- Local time
- Today, 15:05
- Joined
- Dec 29, 2010
- Messages
- 130
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...
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/-......
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...
- EmpID
- EmpName
- Sum of No of Days Worked
- Sum of Working Days
- Wage Rate
- Sum of Basic
- 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/-......