I didn't realize i put quotes around it haha.. Ahh i realized why it wasn't working, and I cleared all the values first haha. Also I switched it to yes just in case.

I was using the reference to...

I linked the update query to a button in the course form, and it doesn't work; it says its updating 0 rows.. I think i should reference the form checkbox instead or does it matter? If i should do it...

Hey Tim,

I realized that after as well.
I actually came up with a code not to long after:
UPDATE tblCourse INNER JOIN tblEnrollment ON tblCourse.CourseID = tblEnrollment.CourseID SET...

Hey Tim,

I'm just trying it out now. I tried to build one, but having issues:

SELECT tblCourse.[MandatoryForAll?], tblEnrollment.[MandatoryForEmployee?]
FROM tblCourse INNER JOIN tblEnrollment...

Hey Tim.

I've gone ahead and tried the subreports.. and ive been trying to figure out for the last 2 hours why its screwing it up so much lol... It adds blank pages in between, i tried page breaks...

Hey Tim,

You are always to the rescue..haha

I'm going to work on it tomorrow.

I did a sub-report in a separate report because it would only fit landscape. im going to try doing subreports...

Just an update - i'm hoping to sit down and check that query out this weekend. I've been busy with work and school :(. I will keep you posted.

Hey, again I grace you guys with another question.

I've run into another speed bump - REPORTING! I didn't create the database - just simply adapting it to the needs. It was created externally.
...

Thanks for the response Tim! I'm going to learn the update query and then I'll get back to you most likely next week

Hey Guys,

Some of you know (Tim) that I'm working on a Professional Development and Training Database. I'm about to demo it to HR but I would like to add a feature: If a course is "Mandatory for...

ahh so its not what I'm looking for. In terms of space, having seperate records wouldnt work because It would have to be stored to the program. And arrays are just like a virtual table, like you...

also, i read something about cross tab queries, however, i'm not sure if thats what I was looking to do.

Hey guys,

Although I decided against using a listbox and simply just using a subform, I did spend a lot of time trying to figure out how to get the listbox to store more than one values for that...

Hey Tim,

Thanks for your response. Yes, I was thinking employees and courses should have a many-to-many but I'm glad to hear I've already done that (haha) as well as that I've got the right...

Hey Guys,

I'm building a database that will be used to track the professional training and development courses employees take at my work. I'm relatively new to db's, and I find the relationships a...

also, do you know of a good site or book that will walk me through SQL in Access- from beginner to this level??

Hi Timothy,

Thanks for the great response. That really helped alot espescially since your database is more simplified and less information. Again Sorry for the late response, it is not my top...

Sorry for the late reply. I appreciate your quick response. Without giving you the extremely long list. ill give you some samples

Whats making this harder is the fact its coming from a form not...

Hi Guys,

I'm new to SQL and just know the basics. My boss has asked me to help him with a new system they are developing using MS. Access.

In the form, the user enters their information as well...

forgot to provide an example:
For example:

Form:
- The client enters their age and employment status
Client Age
Employment Status
Preferred Location (if any)

The criteria is matched up...

Hi Guys,

I'm new to SQL and just know the basics. My boss has asked me to help him with a new system they are developing using MS. Access.

In the form, the user enters their information as...