Access+-+Case+Study+Difficulities


 * **Issue 1** ||
 * ~ Customer Name ||~ Phone ||~ State ||~ PaymentReceived ||~ CountOfPaymentReceived ||
 * Aponte, Elisa || 973-751-9316 || NJ || No || 1 ||
 * Aristotle, Wilber || 203-966-8651 || NJ || No || 3 ||
 * Beck, Ulrich || 508-111-5545 || VT || No || 1 ||
 * Hobbes, Thomas || 208-643-8821 || PA || No || 2 ||
 * Locke, John || 207-792-3546 || NJ || No || 3 ||
 * Machiavelli, Jane || 973-888-9827 || NJ || No || 3 ||
 * Marx, Karl || 973-729-5364 || NJ || No || 5 ||
 * Smith, Adam || 701-888-7778 || VT || No || 3 ||
 * Woodhouse, PG || 616-415-7294 || VT || No || 4 ||

I had so much trouble with Issue 1 that I left it for last. Once I received assistant it made all sense to me. This case study made me like Access a lot more and I want to implement in my job. These are the problems I was having I was not listed the states on separate lines. I was following the book "NJ, VT AND PA" I didn't know where to put the NO's at. After I finish the problem, it made all sense to me and it seem easy after the fact.


 * Field || Customer Name || Phone || State || PaymentReceived || PaymentReceived ||
 * Table || Customer || Customer || Customer || Order || Order ||
 * Total || Group By || Group By || Group By || Group By || Count ||
 * Sort ||  ||   ||   ||   ||   ||
 * Show ||  ||   ||   ||   ||   ||
 * Criteria: ||  ||   || NJ || NO ||   ||
 * Or: ||  ||   || VT || NO ||   ||
 * ||  ||   || PA || NO ||   ||

It took me a while to figure this out and I need help Thank you Sonalben