Hello everyone - I wonder if anyone can help me
I have been left with a database and the request to export specific records from access into the formatted excel worksheet.
I have never done this before and am having some troubles
Problem
What I also need this to do is show the "level" and "hours" from the "tblClass" table
Underneath "class" and "room" when output to the Excel Worksheet
At the moment it exports everything that is needed, except from the "Level" and "Hours"
It really would help me an awful lot if anyone could explain how to do this in specific to the database I have attatched to this post
I have already read a number of Tutorials about this that are scattered around this forum
I have followed links and understand most of it, but there are a few querks specific to this particular small database I would like to understand better.
Admittedly I know very little about making databases etc but sometimes I seem to get forced into the odd one here and there....
Notes**
Before you Begin download the zip attachment and copy The folder "Royal Russell" to the C:/ or it will not work
It has to be placed directly into the C:
Example: C:/Royal Russell/
Once the folder is on the C:/.................
i. First open the Database Named "Student"
ii. You will be prompted to enter a date at the top of the Form
ii. You will need to enter the date of the next coming Sunday for it to work
iii. After you have entered the date Click on the "Sync with Datastore" button
iv. Now click on the "Print Class Register Sheets" button
This will show you the result exported to an Excel Worksheet
Now I just need to get the "Level" and "Hours" to show underneath the "Class" and "Room"
Could you explain how to do this please??
You can find the database here
http://www.mediafire.com/?mzzl4ytjmxd
It would be a great help
I have been left with a database and the request to export specific records from access into the formatted excel worksheet.
I have never done this before and am having some troubles
Problem
What I also need this to do is show the "level" and "hours" from the "tblClass" table
Underneath "class" and "room" when output to the Excel Worksheet
At the moment it exports everything that is needed, except from the "Level" and "Hours"
It really would help me an awful lot if anyone could explain how to do this in specific to the database I have attatched to this post
I have already read a number of Tutorials about this that are scattered around this forum
I have followed links and understand most of it, but there are a few querks specific to this particular small database I would like to understand better.
Admittedly I know very little about making databases etc but sometimes I seem to get forced into the odd one here and there....
Notes**
Before you Begin download the zip attachment and copy The folder "Royal Russell" to the C:/ or it will not work
It has to be placed directly into the C:
Example: C:/Royal Russell/
Once the folder is on the C:/.................
i. First open the Database Named "Student"
ii. You will be prompted to enter a date at the top of the Form
ii. You will need to enter the date of the next coming Sunday for it to work
iii. After you have entered the date Click on the "Sync with Datastore" button
iv. Now click on the "Print Class Register Sheets" button
This will show you the result exported to an Excel Worksheet
Now I just need to get the "Level" and "Hours" to show underneath the "Class" and "Room"
Could you explain how to do this please??
You can find the database here
http://www.mediafire.com/?mzzl4ytjmxd
It would be a great help
