Search results

Hello, I want to be able to display information. This way if someone wants to see what an individual is trained on they can just pull up the matrix chart. Or if they want to see who is trained on a particular task, same thing. Normalized tables? I would have to research that to understand your...

Is there an easy way to create a matrix? I was thinking of a crosstab query, and it seems to fit, but some things I would want to change. This is the layout I am looking to develop, but I wanted to know if it is really possible. Down the left side would be training requirements, across the top...

Got it!! :banghead: Been difficult today, but I appreciate the assist.

Okay.....can't get it to pull over from the form for some reason. Any suggestions? Just getting nowhere today!!:o

Hmm....seems that would work!! Thanks again!

Hey Paul, is there an easy way to get the training description in the column next to the name of the individual lacking training, just as a reminder what training they were running the query on?

Hey!! That works!! Still working on how it works, but it works! I am sure it will take a bit of time for me to figure out! Thanks for the assistance Paul!! :D

If I use the form group training sign-off it will pull up the results based on the type selected. Perhaps this is where I am going wrong?

Very good!! I truly appreciate the assist. I am sure it is something I am missing. :banghead:Here we go!

Is it easy enough to upload a database to have it reviewed? I have the query for the first part. It pulls the employees that have been trained for a particular training type based on a selection on a form, just not getting results on that second part. Or perhaps a small example for me to view.

I can run the unmatched query to find employees that have had no training, but I have several training options. I have a form I want them to choose which training, then get the results of who has not had this training. Does the form pull the results for the second query, because I would need to...

Can I run one query right after another? Basically I use the first query from the form to gather information on employees who match the training I selected, but then I need to run a second query to find those individuals that don't have the training that are active employees. I was able to run...

Hello all, it has been a while since I have worked with Access, and so I have not been here as well. I have a database for training. I have a table of employees with one of the criteria being active which is enabled by a check box. I have a second table of all of the training data. When I add...

Thanks for the help, I found something like this, but it was not working. I do have nulls in both columns. Perhaps there is a way to make them not be null? Will give this a try for sure. Thanks again.

I am not sure this is possible without some programming in the background but thought I would throw it out there anyway. I have a database we are using to track committed shipment dates and revised shipment dates. If we slip on a shipment it gets a new revised date and we let the customer...

Thanks, I did eventually figure it out. It just took longer than expected. Seems I did just like you suggested, so it seems it is good now. Thanks for the response.

Strange this is happening that I didn't realize with this before. The second combobox does update, but I can't select a different date. When I try to choose a different date the combobox updates to the value at the top of the list. Why would this be?

I decided to load the database so that you can have a closer look at what I am trying to describe. If you start out at the form Navigation and choose new you can follow the path basically. Simply choose a name and a date on the next form enter 123456 as the password and it will open the...

I have been working on a timesheet program, and I believe I am pretty close to being completed with the input functions, but I have run into a snag. I have a form that basically directs a person to add a new timesheet or edit an old timesheet. I have two comboboxes and I have been able to set...

Got it just after sending the last message. :o