Hi Mick,

What is an Excel NG? Also I am not sure what codes would be helpful to see this is the sql statemet if this helps;

SELECT resource_0.resourceID, resource_0.generic, resource_0.productcode, resource_0.department, resource_0.category, resource_0.subcategory1, resource_0.name, resource_0.description, resource_0.nominalcode, resource_0.serialnumber, resource_0.barcode, resource_0.purchaseprice, resource_0.purchasedate, resource_0.purchaseauthorisationnumber, resource_0.notes, resource_0.jobID

What I was really wanting was just a statement to put in the criterea of a query so that when a parameter field is left empty it shows all the results instead of limiting it to what you have but in the field.

Thanks