If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with report...need to list if any info was missing from application.
Hello
I am creating an Interview schedule report for the Faculty of Medicine Admissions. Before this year they did it by hand...but now that we have more info captured in the database I thought this could be done in a report. The part I am wondering about is this: The report identifies the time of their interview (got that done) but also needs to list if any pertinent info hasn't been received by the office yet) So...the report needs to check the database for missing transcripts (there is a University/College Name field....a TranscriptReceived checkbox and a DateReceived textbox) Missing References and missing MCATs (both of these have the same type fields in the database as the transcripts) What would be the best way to set this up...so that it only lists the missing info...keeping in mind that there might be none missing...might be 1 or more than 1 not there. Thanks! |
#2
|
|||
|
|||
Help with report...need to list if any info was missing from application.
Jacqueline wrote:
Hello I am creating an Interview schedule report for the Faculty of Medicine Admissions. Before this year they did it by hand...but now that we have more info captured in the database I thought this could be done in a report. The part I am wondering about is this: The report identifies the time of their interview (got that done) but also needs to list if any pertinent info hasn't been received by the office yet) So...the report needs to check the database for missing transcripts (there is a University/College Name field....a TranscriptReceived checkbox and a DateReceived textbox) Missing References and missing MCATs (both of these have the same type fields in the database as the transcripts) What would be the best way to set this up...so that it only lists the missing info...keeping in mind that there might be none missing...might be 1 or more than 1 not there. Kind of the reverse of whet most people want, but you can essentially do it the same way. Add some code to the Format event of the section containing the controls bound to the fields you do/don't want to appear. Assuming these fields have a Null value when they're missing their data: Me.TranscriptReceived.Visible=IsNull(Me.Transcript Received) Me.DateReceived.Visible=IsNull(Me.DateReceived) . . . Then set each of those control's CanShrink property to Yes. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Help with report...need to list if any info was missing from application.
Thanks for the response...
Actually what I need to do is find where the TranscriptReceived checkbox is No (values for this field are 0 and -1)...and display the University name that is associated with that checkbox equaling No...make any sense? Then I have to do the same for References and MCATs...but I think in the report they only want the sections that are missing to be displayed... -----Original Message----- Jacqueline wrote: Hello I am creating an Interview schedule report for the Faculty of Medicine Admissions. Before this year they did it by hand...but now that we have more info captured in the database I thought this could be done in a report. The part I am wondering about is this: The report identifies the time of their interview (got that done) but also needs to list if any pertinent info hasn't been received by the office yet) So...the report needs to check the database for missing transcripts (there is a University/College Name field....a TranscriptReceived checkbox and a DateReceived textbox) Missing References and missing MCATs (both of these have the same type fields in the database as the transcripts) What would be the best way to set this up...so that it only lists the missing info...keeping in mind that there might be none missing...might be 1 or more than 1 not there. Kind of the reverse of whet most people want, but you can essentially do it the same way. Add some code to the Format event of the section containing the controls bound to the fields you do/don't want to appear. Assuming these fields have a Null value when they're missing their data: Me.TranscriptReceived.Visible=IsNull (Me.TranscriptReceived) Me.DateReceived.Visible=IsNull(Me.DateReceived) . . . Then set each of those control's CanShrink property to Yes. -- Marsh MVP [MS Access] . |
Thread Tools | |
Display Modes | |
|
|