View Single Post
  #1  
Old May 27th, 2010, 03:16 PM posted to microsoft.public.access.forms
Konchetta via AccessMonster.com
external usenet poster
 
Posts: 31
Default Datasheet Subform Query

I have a Datasheet subform for which I have a field name CalendarYear which
basically lets me know that fees were received for that Calendar Year. I have
entered information for the 2009 Calendar Year and some information for the
2010 Calendar Year. I am trying to get my query to give me all records for
which fees have not been received for the 2009 and 2010 Calendar Years. I
tried the NULL function but that isn't working or maybe I am not using it
correctly. I placed IS NULL in the criteria for Calendar Year. Can this not
be done in a datasheet?

Thanks in advance for your assistance!!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1