Hi, I have an assignment where I must create a query that displays the first eight characters of the employees’ last names and indicates the amounts of their salaries with asterisks. Each asterisk signifies a thousand dollars. My question is how do I select a value and display it as asterisks and how do I make it so that for every 1000 there should be 1 asterisk. Any help would be much appreciated
Welcome to the forums!
You said this is an assignment, as in course/university work? If so, many forum members hesitate to give out canned answers because it really won't benefit you, the student.
If my assumption is correct you would be better off showing what you have tried so far so we can lead you in the right direction.
My apologies if my assumption is incorrect.