ADD +1 to the filed PAX

[sal21]

sql="INSERT INTO PRENOTAZIONI ([IDTIP], [TIPO], [DAL], [AL], [MM], [AAAA], [NRGG], [AGG], [IDCLI], [PAX]) VALUES ('10','SINGOLA','15/06/2021','21/06/2021','6','2021','7','17/06/2021',0015, [PAX]+1)"

i need to add +1 to he existing value in PAX...

Have error!

note:
PAX have a numeric field property

[HansV]

This SQL insert a new record into the table. It does not update existing records, so I don't understand what you mean by "the existing value in PAX".

[sal21]

This SQL insert a new record into the table. It does not update existing records, so I don't understand what you mean by "the existing value in PAX".

sorry, wrong post.