Wednesday, August 10, 2011

I'm having a problem with a computer cl Microsoft Access related ignment, can you help me?(Again)?

Maybe it's the wording that's throwing me, but I have a predesigned database with supposed errors I have to fix. One of the errors says the fields First Name, Last Name, Street, and City appear in the proper order, but are sorted incorrectly. The wording on the next part throws me as it says the query results shold be sorted by last name within city in ascending order. Well, the Last Name and City fields are both already sorted in ascending order, but the wording of by last name within city confuses me. Another ignment or part of the same one throws me. It says when you try to run the query a message in the following picture appears, but it's a message asking for the parameter value of Amount which it seems it's supposed to do. It details how the two tables provided are joined to display the different fields, that the query calculates the total amount for each customer, and that the query should be sorted in alphabetical order by worker last name and customer last name, which led me to sort them in ascending order. It next says correct the error that is causing the message shown in the picture and sort the records properly. It doesn't seem to be an error message, but maybe it isn't needed. I wouldn't know how to get rid of it as I see no criteria listed that is causing it in the first place. I just am confused by the wording maybe. Pls let me know if you can help.

No comments:

Post a Comment