Question
Im doing a microsoft access assignment and its called creating an electronic accessaries database. Im stuck with the queries. im on question 4 and im
Im doing a microsoft access assignment and its called creating an electronic accessaries database. Im stuck with the queries. im on question 4 and im not sure how to do it.
4. Display the Sales Rep ID, Full Name, Outlet ID, Quota, and YTD Sales for all Sales Reps with a quota of more than $2,000,000 and an Outlet ID of HME 17.
5. Display the Sales Rep ID, Full Name, Outlet ID, and YTD Sales for all Sales Reps with a Sales Rep ID that begins with 6.
6. Display the Sales Rep ID, Full Name, Hire Date, and Quota for all Sales Reps with a hire date before June 1, 2004 or a quote of less than $2,000,000.
7. Display the Sales Rep ID, Full Name, Outlet ID, and YTD Sales for the top 4 Sales Reps with YTD Sales greater than $1,500,000 and less than $3,000,000.
8. Display all fields from the Sales Reps table sorted in descending order by Full Name within Outlet ID.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started