Forum home » Delegate support and help forum » Microsoft Access Training and help » Keeping a log of meetings in an access table
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Keeping a log of meetings in an access table
Resolved · Urgent Priority · Version 2003
Reply Wed 15 Apr 2009, 10:31Delegate Natalie said...
Natalie has attended:
Access Introduction course
Keeping a log of meetings in an access table
I am creating a client database and I want to have the company name, type of company, date of meetings and comments on the meetings as fields. How do I create a meeting log like the below in an access table so that when I then put it into a form/run a report you see the whole log for each company not just the first one? Access seems to want to recognize each line separately.
Company name Type Date of meeting Comments
ABC ABC 04/04/2009 xxxxxxx
14/04/2009 xxxxxxx
Hope that makes sense.
Thanks,
Natalie
For upcoming training course dates see: Pricing & availability
RE: Keeping a log of meetings in an access table
Dear Natalie
Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.
I hope you remember covering Reports using the Wizards during your training.
The answer to your query is quite simple.
I am assuming that you have already created the table for the meeting log.
Please follow these steps:
1. Choose the Reports button from the Objects bar on the Left hand side
2. Choose New button.
3. On the New Report Dialog box choose the Report Wizard and from eth drop down arrow choose the Table that contains the Log of the meetings
4. Choose the fields you want to have in your report by using the single arrow or Double arrow if you want all the fields from the table onto your Report. Press NEXT button.
5. In this step called Grouping. Choose the field called Company Name and double click on it so that it appears on the right hand window and becomes Blue. Press NEXT
6. Choose the Field to sort. I would advise the Meeting Date field to be sorted and have it Descending so that you can see the latest meeting on the top. Press The NEXT button
7. Choose the Layout of your choice. Press NEXT
8. Choose the Style of your choice. Press NEXT
9. Give an appropriate name to the report and then press the Finish button.
You should get the desired result where you will see the name of the company only appear once and the relevant information about the company will be indented and the date will be sorted descending.
Please note that I have attached a database file with some dummy data for your reference!!
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
Attached files...
Meeting LOg.mdbReply Wed 15 Apr 2009, 14:31Delegate Natalie said...
RE: Keeping a log of meetings in an access table
Hi Rajeev,
Many thanks for the speedy response. That all makes perfect sense, however when I go through the process and click the finish button, it comes up with a box saying 'the wizard is unable to create your report' but no other explanation is given. Do you have any idea why this is happening? Even in the file you sent me, I cannot open the report (although I can open the table) and when I run another report off the table you have created it comes up with the same message.
Many thanks,
Natalie
RE: Keeping a log of meetings in an access table
Dear Natalie
Thank you for response!!
Normally sometimes Access cannot detect the printer installed on your computer and therefore the wizard especially for report goes a little crazy. This is particularly the case when you have a network printer.
Please refer to the following link and see if this resolves your problem:
http://www.access-programmers.co.uk/forums/showthread.php?t=73782
This is another link which suggests updating the driver for the printer:
http://www.pcreview.co.uk/forums/thread-1660089.php
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
|