Hi

I was wondering if update queries can update more than one field without having to click it numerous times.

e.g. i have 4 fields to update. I have to click update 4 times.

I have never learnt modules and im not suppose to use them in my assignment.

thanks :D

As long as the columns are in the same row and all are using the same criteria;
UPDATE xxx
SET Col1 = "test", COL2 = 1234, COL3 = "Hello World", COL4 = NULL