I have a M$ Access Database.
There are 2 main tables....one contains a persons name and address details.....the other is linked to this and contains various dates that the person attended.
I want to get a list of names and address for anyone who hasn't attended since 1st Feb 2008. Something like Where Date <= 01/02/2008 NOT > 01/02/2008
I am mega rusty with Access could anyone tell me the quickest and easiest way to do this.
THANKS
EDIT: I can get it to display the records using <#01/02/2008# I am unsure of the syntax to stop it including any that have been >#01/02/2008#
Social Networking Bookmarks