Hi,
I was wondering if anyone can help with this. I am a basic user of Access, so apologies if this is really easy.
I have a list of id numbers, and I have a list of dates.
I want to write a query criteria that will show me all the information on ID numbers that have a blank value in the end date column
Can I write a criteria query that will show this?
Source Data ID Start End 1124 1/01/2014 1/02/2014 1123 1/02/2014 1/02/2014 1124 2/01/2014 15/02/2014 1123 3/01/2014 Want to display ID Start End 1123 1/02/2014 1/02/2014 1123 3/01/2014
Is this possible?
Thanks, Susan