Hello,

>> How can i get all the results if no input parameter is put in the query e.g. if i have A,B,C and need to get all results, only A, only B and only C?

>> How can i block 1 cell and only acess it if the last cell have a correct value?

Thanks in advance,
Kobee

1. Your criteria needs to be something like:
Where (fldA = Forms!YourForm!fldA Or IsNull(Forms!YourForm!fldA) AND (fldB = Forms!YourForm!fldB Or IsNull(Forms!YourForm!fldB) AND (fldC = Forms!YourForm!fldC Or IsNull(Forms!YourForm!fldC);
2. Tables do not have cells. Spreadsheets have cells. I don't know what you are talking about.

2nd Question.

what i need is to only accesss the second field if the first field has a value.

_________13_
____________ -> Now i can insert a value here because the first field are not NULL.


Thanks in advance

You will have to create a form to use to enter the parameters. You can't do what you are asking in the query itself. The criteria will get too complicated.