Josie, did you just respond? I tried accessing your response here but no luck.
Hi, I need someone who is knowledgeable with Microsoft Access to do what my teacher didn't, which is write down an explanation/solutions for how to do a fairly simple assignment. I can copy and paste it here. I'm using Office 2013.
I just uploaded it. Can you let me know if you receive ok? What I'm looking for is a step-by-step. We did the assignment in class, but I learn better by reading than by watching the steps.
Does this work?
Ok, thanks again. Here's the new link:
Hi again Doctor,
Thanks for doing this so quickly. We've got a test in a few weeks & Access will be a part of it.
If it's ok with you, I'll likely have some questions on some of these. Is it ok to email these? One in particular was regarding the items under $5. The list that the query generated had several duplicates. I tried everywhere to find out how to hide the duplicates but couldn't find a clear answer.
Hello again,If you followed the instructions that I sent correctly, there are absolutely no duplicates. I ran each query myself. If you are getting duplicates, then you didn't do something correctly. You can zip up your modified database file and send it to me. Tell me what the query is called and I will take a look at it.Please remember to rate my answer. You may ask follow up questions before or after leaving a positive rating.
Ok, thanks again. Give me a day and I'll rate and pay the balance.
Hi Doctor,I've been so busy that I haven't even had time to review. I've got 2 full-time jobs and my time is not my own! I will look it over today though. Will you be around for a question or two?Thanks,Jason
Thanks again for your help. I'd benefit with screenshots of some of the steps you've outlined.
Here's mine for #4. I'm following your directions as written but getting error messages. Here's a link to the screenshot:
Also, can this email be set up instead to accept attachments? My files aren't large and the extra step of the cloud is creating more work.
Hey -- you know what? I've had about all I can take of your sniveling condescension for one lifetime.
I followed your directions and tried entering Sales : OrderID in the 4th field from the left. It gave me an error message, so I tried entering it in table #1.
No thanks -- I would like someone else to assist.
Hello again Jason,I am sorry that you feel that way.You can download the database file here:http://wikisend.com/download/175792/northwind(1).mdbIn the file there is a query called QUERY4-DONE.You will see the query in question, exactly as the instructions state. Simply press the run button in the ribbon and you will see that it runs without an error.You asked for instructions on 10 queries and received accurate, step-by-step, instructions for each. If you need each of the 10 queries completed for you, simply state so.I apologize that you are frustrated and read a tone into my text that was absolutely not there. I am more than willing to help you and have, from the beginning, offered many different options for you to send me what you have done so that I can provide feedback.I have offered the completed file. I have offered to review your file. I have offered to take a screen cast of each step being completed. I thank you for sending a screen shot, but there is not much I can do with that. You stated that you tried to follow the instructions before and then moved the Sales : OrderID after it didn't work. But I never had an opportunity to see that "not work" or what you could have done wrong. That is why I have suggested multiple times that you save your files with the issue in it and send it to me so that I can provide you with feedback.
Why I have offered a couple different times to send you the file with all of the queries completed is so that you could see the steps completed. This has the same affect as a screen shot, but you would also be able to play around with the queries, view the SQL, change conditions and see what happens, etc. You could still complete everything in your file, but have a file to go to and see if you got it right or what you need to do when you get stumped.
In any case. I again apologize that you appear to be frustrated. If you would like the completed file, just let me know. I would be happy to send that to you.
Thank you so much and have a wonderful day.
Hello again Jason,I wanted to send you these couple files:http://wikisend.com/download/314926/northwind.zipIn that zip is the instruction file with screen shots for every question. And in the accdb file, you will find every query completed. They are named Query3-Done, Query4-Done, Query5-Done, etc.You can, of course, work with a different professional. I just wanted to make sure that you had these files.Thank you so much for your question and have a wonderful day!
No unfortunately, I still would like the assistance that wasn't provided. I paid the $60 and am not asking for a refund, but I would appreciate the help from someone else who provide what I asked for on 7/14. Can someone please do this? I work full-time and have been looking forward to this assistance, especially after calling in an sending a seaparate email as requested.