query

sadie

Registered User.
Local time
Today, 19:34
Joined
Apr 11, 2003
Messages
115
I have a field in a query [next review date] which is based on my field [date]+365

The query looks good

When I enter the criteria under next review date I enter
is nopt null and [please enter month followed by /*/*] so I can easily pull up all the reviews due in a particular month

I t works in my other databases but it is blank here...is it because it is based on a field with an expression or something?

Thanks
 
sorry, I just realized I left out the word like and now it works
I feel so dumb
 

Users who are viewing this thread

Back
Top Bottom