I have a database which shows students list, with marks and pass %. I want to create a report based on this on another sheet. Whenever I update the source file, I need automatic updation in the destination file
An expert who has achieved level 3 by getting 1000 points
An expert that got 5 achievements.
An expert who has achieved Level 3.
An expert that has over 500 points.
Re: Creating a report
I assume you are using excel? to get the new sheet auto update try this formula =sheet1!C5 into the new cell in new sheet (eg. sheet2)
whenever you update sheet one cell C5 it will automatically appear in new sheet...
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
When putting files up on your hosted site (or on your own server), make sure the file and the directory have the proper writes to Read/Write/Create. A special file called the .LDB file must be created and if it can't a ReadOnly status could be issued. It's a file that contains the names of the users currently accessing the MDB file. It stands for Lock Database. If you are running on Windows add these attributes, if it's linux (not sure why you'd use MDB on a LINUX box, but it would be chmod +777.
Go to tools and goto the print labels and start a new label. It will ask you to creat one or merge from a data base and at that point you can create your own. Save it and then you will use Data merge to merge it back into the document.
I ask you to do it this way, since you will ultimately use it in this capacity.
you can create static data base in Excel works heet and link each cell to another sheet.
or you can create a dynamic data base in access. you need a MS access book. there are lots link you need to understand in order to have a working data base.