B
bhrosey via AccessMonster.com
Ihave a very simpe form with 3 Cbo's on it:
Employee name
Start Date
End Date
My main table stores tasks that each employee has done and when they did them.
I have a report based a query so that I can see everything an employee has
done within a certain date range. Originally I had a form with just employee
Cbo which gave me everything the employee has done throughout history.
Another form with a calendar and start and stop Cbo's which gave me data
withing that date range, but for every employee. I created this new form so
that I could see just one employee within the specified dates. The problem
is this...in the criteria for my query in the empl field I referenced the emp
Cbo and in the date field criteria I put...between [forms]![FormName]!
[CboName1] and [forms]![FormName]![CboName2], but when I have the form open
and enter all 3 pieces of information and click the command button, I still
get everything for that employee, regardless of the date. What am I doing
wrong?? Thanks for the help!!
God Bless!
Bill R.
Employee name
Start Date
End Date
My main table stores tasks that each employee has done and when they did them.
I have a report based a query so that I can see everything an employee has
done within a certain date range. Originally I had a form with just employee
Cbo which gave me everything the employee has done throughout history.
Another form with a calendar and start and stop Cbo's which gave me data
withing that date range, but for every employee. I created this new form so
that I could see just one employee within the specified dates. The problem
is this...in the criteria for my query in the empl field I referenced the emp
Cbo and in the date field criteria I put...between [forms]![FormName]!
[CboName1] and [forms]![FormName]![CboName2], but when I have the form open
and enter all 3 pieces of information and click the command button, I still
get everything for that employee, regardless of the date. What am I doing
wrong?? Thanks for the help!!
God Bless!
Bill R.