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!

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]

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]
.