1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
mixer [17]
3 years ago
5

Type an SQL statement into the Record Source property of the report. The statement should select all fields (*) for employees wi

th the Sales Representative title.
Computers and Technology
1 answer:
Vedmedyk [2.9K]3 years ago
4 0

Answer:

SQL statement into Record will be

SELECT * FROM Employee WHERE Employees.Title LIKE "Sales Representative " OR Employees.Title Like " Sale Manager

SELECT " FROM Employee WHERE Title =" Sale Representative and Title = " Sale Manager.

Explanation:

Like to do string comparisons have used and it is depend upon the database that are using.

If you are sure that title column has Title Representation and Sales Manager then you need to list the column and used single instead of double quotes and use OR instead of AND

if you are sure about Title column then use % match zero or more in the statement as well.

You might be interested in
System uses a 6-bit 2’s complement signed integer representation. What is the range of decimal values it can represent?
kap26 [50]

Answer:

-32 to +31

Explanation:

6 bit 2s complement representation will be of the form b1b2b3b4b5b6 where each bit is either 0 or 1.

The largest positive number that can be represented using this scheme is 011111

Translating this to decimal this is 1*2^4 + 1^2^3 + 1^2^2 + 1^2^1 + 1^2^0

=16 + 8 + 4 + 2 + 1 =31

The smallest negative number that can be represented using this scheme is 100000

Translating this to decimal = -1 * 2^5 = -32

So the range of decimal values that can be represented is -32 to +31.

6 0
3 years ago
Last month Joe purchased some stock in Acme Software, Inc. Here are the details of the
fiasKO [112]

Shares_Purchased = 0.0

Amt_PaidPerShare = 0.0

Commission_Percentage = 0.0

Paid_WithoutCommission = 0.0

Commission_Paid = 0.0

Total_Paid = 0.0

Shares_Sold = 0.0

Amt_SoldPerShare = 0.0

Sale_Amount = 0.0

Earned_WithoutCommission = 0.0

Commission_PaidSale = 0.0

Total_Earned = 0.0

ProfitNoProfit = 0.0

#calculation starts from here

Shares_Purchased = float(input("How many shares did you purchase? \n "

"enter in 0.0 form: "))

Amt_PaidPerShare = float(input("How much did you pay per share? \n"

"enter in 0.0 form: "))

Commission_Percentage = float(input("What percentage is your stockbroker \n"

"Charging per transaction? enter in 0.00 form: "))

Paid_WithoutCommission = Amt_PaidPerShare * Shares_Purchased

Commission_Paid = Paid_WithoutCommission * Commission_Percentage

TotalPaid = Commission_Paid + Paid_WithoutCommission

Shares_Sold = float(input("How many shares did you sell? \n "

"enter in 0.0 form: "))

Amt_SoldPerShare = float(input("How much did you sell each share for? \n"

"enter in 0.0 form: "))

Earned_WithoutCommission = Amt_SoldPerShare * Shares_Sold

Commission_PaidSale = Earned_WithoutCommission * Commission_Percentage

Total_Earned = Earned_WithoutCommission - Commission_PaidSale

ProfitNoProfit = Total_Earned - Total_Paid

#printing the output

print ("You paid the following for the shares:")

print (Paid_WithoutCommission)

print ("You paid the following in commissions to your stockbroker for the purchase:")

print (Commission_Paid)

print ("In total, you paid:")

print (Total_Paid)

print ("You sold your shares for the amount of:")

print (Earned_WithoutCommission)

print ("You paid the following in commissions to your stockbroker for the sale:")

print (Commission_PaidSale)

print ("In total, your revenue is: ")

print (Total_Earned)

if ProfitNoProfit > 0:

   print ("You have earned a profit of: %s." % ProfitNoProfit)

elif ProfitNoProfit == 0:

   print ("You have broken even")

else: print ("You have lost this amount: %s." % ProfitNoProfit)

5 0
3 years ago
Alan is working on a draft document. He wants the document to have more white space. He can do this by changing the line spacing
Alex

It is a true statement that changing the line spacing will make the document have more white space.

<h3>What is a line spacing in word document?</h3>

This refers to the distance between upper and lower lines of text.

These line spacing are tools that make text much more readable because its places distance between the word lines.

By using a line spacing, there will be more spaces and white spaces on the word document.

Therefore, the statement is a correct statement.

Read more about line spacing

<em>brainly.com/question/25277953</em>

8 0
2 years ago
What utility is used to verify that tcp/ip installed, bound to the nic, configured correctly, and communicating with the network
klasskru [66]
<span>PING is a utility that can verify that TCP/IP is installed, bound to the NIC, configured correctly, and communicating with the network. Ping is used diagnostically to ensure that a host computer the user is trying to reach is actually operating. Ping works by sending an Internet Control Message Protocol (ICMP) Echo Request to a specified interface on the network and waiting for a reply. Ping can be used for troubleshooting to test connectivity and determine response time.</span>
6 0
4 years ago
Complete the sentence.
Advocard [28]

The Hard drive storage is not recommended for long-term archiving because the storage media can degrade over time.

<h3>What is Long-term archiving?</h3>

Long-term archiving is known to be the act of  getting data, that are long-term in terms of accessibility and intelligibility.

Therefore, The Hard drive storage is not recommended for long-term archiving because the storage media can degrade over time.

Learn more about  Storage from

brainly.com/question/24227720

#SPJ1

7 0
2 years ago
Other questions:
  • To reach fifty million users, it took _____.
    10·2 answers
  • The wireless spectrum, as defined by the fcc, spans between which two frequencies?​
    7·1 answer
  • Using underlining and italics at the same time is which of these? A. allowed but might be overkill B. always a good idea C. not
    15·2 answers
  • Robert’s computer is not working properly. It has become too slow to respond to programs. What can he do to maintain his compute
    15·1 answer
  • The __________ method can determine whether a string contains a value that can be converted to a specific data type before it is
    12·1 answer
  • When entering a formula into a cell, you begin with are calculations a spreadsheet program applies to data. are preset calculati
    9·1 answer
  • anyone here done intro to tech course on edgenuity yet? I failed the first unit test twice and it's prob gonna be a third if i r
    14·2 answers
  • Edhisive 3.5 code practice
    9·1 answer
  • Can some help me on this"..... / ..--- ..--- / ..... / .---- ---.. / .---- ----. / ..... / ..... / .---- ....- / ..--- ----- / .
    6·1 answer
  • ravi met few peoples in a party and was mixing up well those wearing expensives clothing and fair complexion . which factors are
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!