Hi everyone,
I need help with my homework's and project for this class
my homework for next class is this
Create a query to list all employees alphabetically first by employee type name, and second by employee
last name, and third by employee first name. Name your query PE1-qryEmployeeByType.
2. Create a query to show a count of employees by EmployeeTypeName. The names should be in alphabetical
order. Name your query PE2-qryCountOfEmployeeType.
3. Create a query that finds the earliest date a payment was made for every purchase that have at least one
cash disbursement associated with it. Sort your results in ascending order by ReceivingReportID. Name
your query PE3-qryEarliestPaymentForPurchase.
4. For each purchase that has at least one related cash disbursement (see Practice Exercise 3), create a query
to compute the number of days between the purchase date and the first payment for that purchase. Sort
your query by purchase. Name your query PE4-qryDaysToPayForPurchases.
if you could help me i will provide you with the database and if you could tutor me also would be great
thank you