I am trying to develop a report which is basically a letter we mail out.
Currently it is linked to a query and when the report is run we have to enter the unique ID number for a person. The query then returns what courses they have done, the dates and the duration in hours. Even includes multiple courses so that is all fine.
Then I need a further section which lists the courses they are on a waiting list for. I feel I need a further query for this section. The above query hinges on the Completed Date field and has Is Not Null to filter everything, so only courses completed are listed.
In the latter area I need the Commencement Date Field to have Is Null so they come up as on the waiting list, as they have not commenced.
How do I get this second section on the same report so it prints as a one page letter?
Currently it is linked to a query and when the report is run we have to enter the unique ID number for a person. The query then returns what courses they have done, the dates and the duration in hours. Even includes multiple courses so that is all fine.
Then I need a further section which lists the courses they are on a waiting list for. I feel I need a further query for this section. The above query hinges on the Completed Date field and has Is Not Null to filter everything, so only courses completed are listed.
In the latter area I need the Commencement Date Field to have Is Null so they come up as on the waiting list, as they have not commenced.
How do I get this second section on the same report so it prints as a one page letter?
