Jeff,
I tried the crosstab query route with no success. I am getting an error
because of the query I created to check all labs completed for each
employee
to see if the course certificate is earned. The lab completions are
entered
in on a daily basis and this query takes that table (data entry) and
matches
it to the requirements for each certificate. This is how I am able to show
which certificates have been earned.
SELECT [tbl Associate].[Associate ID], [tbl data entry].[Job Type], [tbl
Associate].FirstName, [tbl Associate].LastName, [tbl Associate].StartStep,
[tbl Associate].[Program Start Date], [tbl certificates].Certificate,
a.[Certificate Code]
FROM (([tbl data entry] INNER JOIN [tbl Labs] AS a ON [tbl data
entry].[Training Code]=a.[Training Code]) INNER JOIN [tbl Associate] ON
[tbl
data entry].[Associate Number]=[tbl Associate].[Associate ID]) INNER JOIN
[tbl certificates] ON a.[Certificate Code]=[tbl certificates].[Certificate
Code]
WHERE ((([tbl data entry].[Job Type])="TDP"))
GROUP BY [tbl Associate].[Associate ID], [tbl data entry].[Job Type], [tbl
Associate].FirstName, [tbl Associate].LastName, [tbl Associate].StartStep,
[tbl Associate].[Program Start Date], [tbl certificates].Certificate,
a.[Certificate Code]
HAVING (((Count(*))=(SELECT COUNT(*) FROM [tbl labs] WHERE [certificate
code] = a.[certificate code] )));
I am not sure if I can add something to this query that sets the associate
and all certificates earned by that associate as one record. Any
suggestions?
Jeff Boyce said:
It might be that you could use a cross-tab query. Check on that (Access
HELP).
Regards
Jeff Boyce
Microsoft Office/Access MVP
Jeff,
I am wanting the outcomecome to show the employees name, with all
checkboxes
in a row under his/her name with the ones completed being checked. I
have
this set up and working (checkboxes work that is) but if there is more
than
one completion for an employee, they show up as seperate records.
example: John Doe
Checkbox 1 | checkbox 2 | checkbox 3 | and so on. Lets sya John Doe
has
checkbox 1 & 2 complete (theses are actually courses) what I get as an
out
come is this:
John Doe
Checkbox 1 - checked
John Doe
Checkbox 2 - checked
I want the outcome to be:
John Doe
Checkbox 1 - checked | checkbox 2 - checked
I hope I am making a little more sense to you. Thanks
:
So it sounds like you are saying "one checkbox per course" (i.e., per
record). Back to your original post ... why is it a problem when one
person
has more than one checkbox (errr, record)?
What is it that you are trying to do with the information?
Regards
Jeff Boyce
Microsoft Office/Access MVP
Jeff,
Sorry I didn't get back to you sooner. The form is based off of a
query
that
shows courses completed per employee. The query groups all labs
required
for
each course. The checkboxes are for each course. If the course is
complete,
then the checkbox is checked. This works, but if an employee has
more
than
one course (step) complete, than each is shown as a different
record.
Thanks
:
Forms are based (at least, bound forms are based) on underlying
data,
either
a table or a query. What is your form based on?
What are the checkboxes based on (i.e., what field/fields are they
bound
to)?
Regards
Jeff Boyce
Microsoft Office/Access MVP
I have a form I am trying to create that has a total of 8
checkboxes
that
are
checked depending on if the criteria is met. The problem I am
having
is
that
if there is more than 1 checkbox checked, they show up as
different
records
instead of being on one record. Is there a way around this?
Thanks