Hello Everyone!
I'm in a bit of a mess. I'm building my first larger database for an organization which visits schools delivering education. Before we visit a school we make a 'contract' which we send by snailmail to the school. I have a vision on how to solve my problem with Access but I don't know how to get there.
I want a table where all the appointments are (with schoolname, date, time, educator and so on).
And then I want a report that has to work as a template in a way. So that I can make the report look like our contract and make access fill in the neccesary information from the table described above - so it's ready to be printed. Is it possible (and how) to make a query when clicking the report, you have to write the date and the school name, and then the report is filled with the matching post from the table?
Please help
\Jesper
I'm in a bit of a mess. I'm building my first larger database for an organization which visits schools delivering education. Before we visit a school we make a 'contract' which we send by snailmail to the school. I have a vision on how to solve my problem with Access but I don't know how to get there.
I want a table where all the appointments are (with schoolname, date, time, educator and so on).
And then I want a report that has to work as a template in a way. So that I can make the report look like our contract and make access fill in the neccesary information from the table described above - so it's ready to be printed. Is it possible (and how) to make a query when clicking the report, you have to write the date and the school name, and then the report is filled with the matching post from the table?
Please help
\Jesper