Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help on the last part!!!! add a new field named Number of Advisees, which counts the number of advisees per advisor. how do

I need help on the last part!!!! "add a new field named Number of Advisees, which counts the number of advisees per advisor." how do I do this part only!!! please and thank you
image text in transcribed
Query 4 and Report: Create a query that shows the advisors, their departments, and the number of advisees for each advisor. The fields you need to add in this query are Deportment 1D, Deportment Nome, Advisor ID, Advisor Last Nome, Rank, Date Joined, and a new field named Number of Advisees, which counts the number of advisees per advisor. Save this query as Query for Report

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Records And Database Management

Authors: Jeffrey R Stewart Ed D, Judith S Greene, Judith A Hickey

4th Edition

0070614741, 9780070614741

More Books

Students also viewed these Databases questions