Firstly, thanks for any help given.<BR><BR>I&#039;ve currently got a query with an Age parameter set up as - [Age] or [Age] is Null. When i run it from Access and leave the prompt blank it retrieves all the records but when i run it from ASP it retrieves none - if I populate my strAge with a value it works fine.<BR><BR>In my code to retrieve all the records I&#039;ve set strAge="" (wondering if this is the problem. The Type is set to adVarChar.<BR>Any ideas ???<BR>Cheers Paul