Outstanding; Thank-you for taking the time to lighten my day.

/Richard

try:

create procedure dbo.myTable_Search

@f1 int = null, -- or whatever type

@f2 int = null,

@f3 int = null,

@f4 int = null,

@f5 int = null,

@f6 int = null

as

select

f1,f2,f3,f4,f5,f6

from

myTable t

where

(

@f1 is null

or

f1...

duh, of course you spotted my foolishness i meant ldb not ldf.

Apologies all round

/Richard

Guys,

Can I correct you: there is an LDF file associated with MS Access. It is a Locking file and is created when you open an access mdb file; when the...