Urgent Help Needed!!!

[Moongrl]

Hello, I'm new to the board and I need an urgent problem fixed. Ok, I have a query that contains the type of TRAINING REQUIRED FOR EACH POSITION/PERSON IN A COMPANY . It has:-

1. Clock no. (uniqe for each employee)
2. Job Title
3. Position effective date
4. Training code
5. Description of training code
6. Retrain requirements ( number of days that are needed after initial training to reach retraining date, this varies from 0 to 365 days depending on the code)
7. Status of employee (whether active or inactive, the criteria for this is active)
8. Due date for completed training

I have another query which shows the TRAINING RECEIVED FOR EACH EMPLOYEE. IT has:-

1. Clock no.
2. Job title
3.Last names (employee)
4. First name
5. Status of employee
6. Training code
7. Date of training received

QUESTION IS HOW DO I CREATE I GUESS ANOTHER QUERY THAT WILL TELL ME WHAT REQUIRED TRAINING CODES THAT EACH EMPLOYEE HAS NOT RECEIVED? I BASICALLY NEED TO KNOW IF EVERY EMPLOYEE HAS BEEN TRAINED CORRECTLY ACCORDING TO THEIR POSITION OR NOT.

 

[The_Doc_Man]

This has come up before, often enough that it sounds like someone's clever class project. The details are astonishingly familiar.

Search the forum for the topics of "Employee Training" and "Training Courses" to see the previous threads on this topic.

 

[CraigDolphin]

Ye gods...I just answered almost that exact question yesterday. If that's a class project I'm going to be mighty peeved.

 

[Rabbie]

Doesn't the thread title "Urgent Help Needed!!!" send out warning signals.

 

[Moongrl]

Ok, I will search for the topic. I have an urgent need because I need to figure this out for today. I've been trying for days. I must say I just learnt Access so thats why this situation has been so stressful. It makes sense that people have made threads about this befoe because many companies use the program to store employee info. I really hope I find some solutions in previous posts.

 

[rsmonkey]

as people have sed plenty of similar examples floating around.. however first you need to create a list of 'required' training courses if you dont have one already and then compare that to training received query/table whatever.. etc.. abita quick reading on queries and you can have this done in 5 mins!

 

[Moongrl]

Hello once again, I have searched and found similar problems but I dont understand the language. I have just learnt access so I don't know complex terms and the like. Could someone explain this to me simply? I know to set up queries and settign simple criteria but that is it!! I read up on queries but I still dont get how to set up one that does what I want. Believe me I've TRIED.

 

[Rabbie]

If you have searched this forum you will have seen that it is at its best when answering specific questions. Which complex terms are you having problems with? If you ask you may get a reply.

 

[MStCyr]

Good morning

The stated problem is very familiar. A search of this forum will more than likely find the required answer.

I'm hoping that this is not another "demen_demen" situation.


Maurice

 

[boblarson]

I'm hoping that this is not another "demen_demen" situation.

But Maurice - you gotta admit, even though he was a bit profane in the last part of things, he admitted up front that it was something for class, which is actually somewhat rare.

 

[rainman89]

i was thinking that i wanted to see his remark.(demen_demen that is.. i want to see how articulate he really is!)

 

[rsmonkey]

no 'complex' expressions needed moon... can all be done through the query gui grid! (this is me assuming that you are not attempting it via VBA)

 

[Moongrl]

I need the answer to my question which is in the first post for work. What is a query qui grid and how do I set it up? The complex terms ---Im not familiar with all of the terms used. In the other threads people understand the advanced lanugage I dont. I need a step by step breakdown.

 

[Rabbie]

I need the answer to my question which is in the first post for work. What is a query qui grid and how do I set it up? The complex terms ---Im not familiar with all of the terms used. In the other threads people understand the advanced lanugage I dont. I need a step by step breakdown.

Its not QUI its GUI(Graphical User Interface). Its the design grid you see when yoiu are building a query.

 

[Moongrl]

Its not QUI its GUI(Graphical User Interface). Its the design grid you see when yoiu are building a query.

Ok. how do I do it using what you suggested?

 

[rainman89]

there is a wizard in the queries option. in that you will find what he is refering too

 

[Moongrl]

there is a wizard in the queries option. in that you will find what he is refering too

ok but when i build the query do i use simple design, unmatch or what? and then what expressions do i use? criteria etc?

 

[unclejoe]

Hi,

Here's a site for beginners Start Here

Hope it will help you along the way.

ok but when i build the query do i use simple design, unmatch or what? and then what expressions do i use? criteria etc?

 

[Rabbie]

Hi,

Here's a site for beginners Start Here

Hope it will help you along the way.

An excellent link. I am saving it to give to people who want to learn the basics.