Help with displaying items on a report

[Jacqueline]

I am creating an Interview Schedule report in Access 2000
mdb...
All the applicants info is entered on our online
Admissions form...they submit their applications and the
Admissions office can view the application through our
Access frontend.

There are 3 sections...MCAT, Transcript and
References...where the Transcript University/College
name, Reference names and MCAT date are entered by the
applicant...but the Administration have to check a box
when they are actually received by the office and the
date received.

On my report (giving the applicant's interview date and
time) I need to add a section that tells the applicant
what documents haven't been received yet. (of the
3...Transcript, MCAT and Reference letters)

So I would need a way to see what of these 3 checkboxes
aren't checked...and then to display that University
name...or reference name...etc... that hasn't been
received.
I really only need to show the areas that aren't
received... (not the ones that have been)
but am not sure what way to display these in my report...

Any help greatly appreciated.

 

[Marshall Barton]

I am creating an Interview Schedule report in Access 2000
mdb...
All the applicants info is entered on our online
Admissions form...they submit their applications and the
Admissions office can view the application through our
Access frontend.

There are 3 sections...MCAT, Transcript and
References...where the Transcript University/College
name, Reference names and MCAT date are entered by the
applicant...but the Administration have to check a box
when they are actually received by the office and the
date received.

On my report (giving the applicant's interview date and
time) I need to add a section that tells the applicant
what documents haven't been received yet. (of the
3...Transcript, MCAT and Reference letters)

So I would need a way to see what of these 3 checkboxes
aren't checked...and then to display that University
name...or reference name...etc... that hasn't been
received.
I really only need to show the areas that aren't
received... (not the ones that have been)
but am not sure what way to display these in my report...

The key to any report is to get the desired data in a
relatively organized manner. In other words, create a query
that contains all the required fields and criteria to filter
the records to just the needed set.

I don't quite see how your tables are related, but they
should probably be JOINed in some manner and then the Yes/No
field filtered to those that have a value of False. The
query's SQL would have a WHERE clause something like:

WHERE Transcript=False OR MCAT=False OR Reference=False

This query will then supply the report with records where at
least one of those fields has not been checked. The report
will then have to make the text box for the field that was
checked invisible using code in the detail section's Format
event:

Me.txtSchool.Visible = (Me.chkTranscript = False)
Me.MCATdate.Visible = (Me.chkMCAT = False)
. . .

You'll probably also want to set those text box's CanShrink
property to Yes, and, if you do that, set the detail
section's CanShrink to Yes as well.

 

[Guest]

Thanks for the quick response...

The report is based on applicants who have been selected
for an Interview...FinalStatusCode = 1
(dbo_Acknowledgement table)
The Name and Address comes from the Main table dbo_Users
(User_ID is the primary key...and is in all other tables)

The Interview time and date comes from dbo_Interview
table)
The Transcript info comes from a separate table...and the
MCAT and Reference info from their respective tables.

The problem seems to be that we want all the applicants
with a FinalStatusCode = 1 in the query that generates
the report...some of those will have all documents
already in..but others will not...we want everyone to
receive that report...and to also notify the ones with
missing documents to get theirs in.

Make any sense...???

 

[Marshall Barton]

The report is based on applicants who have been selected
for an Interview...FinalStatusCode = 1
(dbo_Acknowledgement table)
The Name and Address comes from the Main table dbo_Users
(User_ID is the primary key...and is in all other tables)

The Interview time and date comes from dbo_Interview
table)
The Transcript info comes from a separate table...and the
MCAT and Reference info from their respective tables.

The problem seems to be that we want all the applicants
with a FinalStatusCode = 1 in the query that generates
the report...some of those will have all documents
already in..but others will not...we want everyone to
receive that report...and to also notify the ones with
missing documents to get theirs in.

Make any sense...???

Sure it makes sense, but there aren't enough details for me
to do the work for you. I'll just give some more general
guidelines to point you in the right direction to construct
the report's query (besides, it looks like you're using MSDE
or SQL Server, which I have no experience with).

If you want to see all the candidates that have a
FinalStatusCode = 1, then that would be the only criteria.

You would not use the criteria I suggested earlier, but
still set the CanShrink properties and include the code in
the detail's Format event.