Hello friends, I have this query but I don't know what FORMAT function really does? can you please tell me what FORMAT DOES?
select emp_num,
total_salary,
max_salary,
Format(total_salary/max_salary) AS percent_sal, (line 4)
Format(total_salary*.25)/max_salary AS bonus_sal (line 5)
From emp;
When I convert this query in SQL view, it don't recoginize this function.
PLEASE HELP.
jENNY.
select emp_num,
total_salary,
max_salary,
Format(total_salary/max_salary) AS percent_sal, (line 4)
Format(total_salary*.25)/max_salary AS bonus_sal (line 5)
From emp;
When I convert this query in SQL view, it don't recoginize this function.
PLEASE HELP.
jENNY.
