Search results for query: *

Ok I following your join there and I see how you are now getting the jobclass and number to equal now how does it pull the description from that line so I can append it to my new table? Thanks

Sure thanks First table is: Payroll 2nd Table is: Departments The payroll table is the imported table, the field I'm looking at is jobclass The second table has 2 fields number and Dept the number is the same as jobClass the dept is is the department description? so when the import table...

Thanks Sorry for not following that but not sure how it refeneces the to numbers to get me my description? For Example when jobclass=number then it should display whats in the departments table dept field? Does that make sense?

Thanks I was on the right track then I did add the second table. How would this query look First table is called Payroll Second table is Departments I pull the Jobclass from the payroll file and it is called the number in the Departments table and what I would like is the to call is the...

Hi Have a table I'm importing from that has job codes these job codes need to be changed to the job description I tried IIF Statement but I have 18 and Access can only handle 10 so I setup a second table with the the jobcode and descriptions How do I take the imported table jobe code and...