Recent content by mojo1979

Hi, I am trying to create a query whereby it will only show only those records when the x field is null. I also need a separate query to do the opposite, i.e. to show only those records which have x field not null. How can I do this? I know I need a statement on the x field but don't know...

Hi, I'm trying to import data from a number of excel spreadsheets (which have the same formating, but saved with different names, and at different locations) into an access table (access 2000 file format in access 2003). Can i create a macro to do this? if so what would it need to consist of...