Keeping a log of meetings in an access table | Access forum

Resolved · Urgent Priority · Version 2003

Wed 15 Apr 2009, 10:31 Delegate 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

Wed 15 Apr 2009, 13:09 Trainer Rajeev said...

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.mdb

Wed 15 Apr 2009, 14:31 Delegate 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

Wed 15 Apr 2009, 14:54 Trainer Rajeev said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips