help with applyfilter

M

mhmaid

I am using cbo box after update event to filter my records on a form by period

if the condition is:
[Forms]![EXPENSE REPORTS BY PATIENT]![TRAVELDateFilter]="2007"

then the action should be : apply filter , where condition = [travel] Like
"*/*/2007"
i have 7 conditions for the years from 2001 thru 2007 .

it was working ok , but with the beggining of the new year it stopped except
with the current year which is the same example givin above. what is the
problem.

what i want is to show the records with travel date for the selected year
only.
 
D

Douglas J. Steele

It should be where condition = Year([travel]) = 2007, or where condition =
[travel] BETWEEN #01/01/2007# AND #12/31/2007#
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top