Search results

I appreciate your time! but it didn't work :(

hello guys! need some help please i have a table on Microsoft access and i would like to use update query to update a column. but instead of creating so many queries i want it to be one query. i tried to do it like the query below but it didn't work. can anyone help please? UPDATE vouchers SET...

Hello guys! I have two tables on access. one called vouchers and the second one is Sales. the Vouchers table is one record for each voucher(one line transaction) the sales table is multiple records for each voucher(multiple lines transactions) I have a percentage column on the voucher's table...

Thank you guys!! I used ABS function in update query as you guys told me and worked! yes I am new to Database world :).

can you explain it please. i know how to use that on excel but not on access. when i try abs function it requires a number but i wanna apply it on the whole column. thank you!

Hello guys! one of my tables has column contains positive and negative numbers(currency). do you know how to make it all positive numbers? if i try to multiply -1 then the positive numbers would convert to negative and i don't want that. Thank you!