Purchase Solution

Access - a few corrections to be made

Not what you're looking for?

Ask Custom Question

Query
In the qry#2TerritoriesAndProducts query:
- sort by product description, then by customer name, in ascending order.

In qry#6ConcatenatedNames:

? sort by Territory Name, Sales Rep Last Name, First Name, Customer Name, Contact Last Name, First Name

(Make sure a comma and a space separate the last and first names in each set of concatenated names.)

? Display Rep and Contact as the headings in the two columns of concatenated field data.

In qry#7ProductAndDateParameter:

? Sort by Customer ID, Customer Name, Product Description, Quantity Ordered, Date of Order

? My explanation isn't visible in the Database window. Please change the view of the window.

Form
1. Both form #1 and form #2 need to have the Navigation Bar displayed at the bottom of the window, so I can move from record to record.

2. In form #2:

? The New England Zip codes are missing their lead zeros in the subform. This is something that occurred in the tables, and must be fixed.
? Item 1 bullet 7: All of the territory names aren't fully displayed.
? the sales rep names aren't fully displayed, some being truncated.

(See question also in attachment)

Thank you.

Purchase this Solution

Solution Summary

The expert examines a code access for a few corrections to be made.

Purchase this Solution


Free BrainMass Quizzes
Javscript Basics

Quiz on basics of javascript programming language.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

C# variables and classes

This quiz contains questions about C# classes and variables.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Basic Networking Questions

This quiz consists of some basic networking questions.