d2jsp
Log InRegister
d2jsp Forums > Off-Topic > General Chat > Homework Help > Access 2010 > Need Help With My Project And Homework
Add Reply New Topic New Poll
Member
Posts: 1
Joined: Apr 3 2013
Gold: 0.00
Apr 3 2013 12:41am
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
Go Back To Homework Help Topic List
Add Reply New Topic New Poll