Can't get the green jelly beans

[Fay Yocum]

I have a database where I track class attendance. I have people that have
taken one of the classes "BLS for Healthcare Provider - Renewal." There is
an entry for the two people in the tblRegistrationLearner table that don't
get pulled into the report. I have tried everything I can think of but can
make it happen. It is like having a bowel of jelly beans, all colors
accounted for. But no matter what I try I can't pull a green jelly bean out
of the bowel.

I have placed a stripped down version at the following location.
www.awarenessproductions.com/db.htm. Click on the link on the page.

On the frmReports do the following
Select All in both listboxes
In date area select After a date. The default date of 08062007 should show.
Click the Certifications button
Select All for the Certification listbox
Select Who has and hasn't..
Click Certifications
Val and Chris will have no entry.

If you go to tblRegistrationLearner you will see LearnerID 254 (Val) has
attended 30-038 and Chirrs (Chris of G-007) attended 30-037.

Any assistance would be appreciated. Thank you for your time.

Fay

 

[Fay Yocum]

Thank you Rob. I knew it was something simple. I thought I had checked that,
but I do have dyslexia so sometimes I can't see the obvious. Thank you so
much.

Fay

 

[Rob Parker]

Hi Fay,

The problem is that tblCertificationTypes has an entry in the Certifications
field (for CertID = 9) which reads "BLS for Healthcare Providers - Renewal".
This is joined to the ClassName field in tblClasses, in the SQL statement
for the MakeTable query which generates tblCombinedCerts; however, in
tblClasses, there is no corresponding entry. There is an entry (for ClassID
= 30) which reads "BLS for Healthcare Provider - Renewal"; if you edit this
entry to match the entry in tblCertificationTypes (add an "s" to the end of
"Provider"), then the MakeTable query will generate an additional two
entries, and those two classes will appear for Val and Chris in the report.

Rob

 

[Jamie Collins]

I do have dyslexia

(From one suffer to another, who's hoping you also have a sense of
humour <g>) I think you meant 'bowl'.

Jamie.

--