Recent content by skcrival

- EDIT - My apologies, I forgot to change Unique Values to "yes". I changed it which it drop to 423 records. I'm still don't understand why "NewPosition" is blank, but you have been a tremendous help to me and I want to thank you for all your time. It is people like you who make a...

Woo hoo! Thanks to your help I was able to join the three tables together, which gives me a total of 423 unique titles. I tried to view the three report tables against the single positions table using: SELECT p.NewPosition, r.Position FROM tblPositions p INNER JOIN ( SELECT Position FROM ECI...

The original three table names are: ECI ECF ECP There are many fields in the three reports but the field containing the job title is "Position" across all three reports. I created three separate queries, SQL as follows: SELECT DISTINCT Position, "" As NewPosition INTO tblPositions FROM ECI...

I massaged the code and tried this: SELECT p.NewPosition, r.Position FROM tblPositions, FROM tblPositions2, FROM tblPositions3 p INNER JOIN ( SELECT Position FROM TableA UNION ALL SELECT Position FROM TableB UNION ALL SELECT Position FROM...

How does the SQL add all the report tables to each other to create one large table? Wouldn't I need to adjust the code to something like: SELECT p.NewPosition, r.Position FROM tblPosition A B & C p INNER JOIN ( SELECT Position FROM TableA UNION ALL SELECT Position FROM...

I tried the first piece of code and it worked perfectly-thank you! SELECT DISTINCT Position, "" As NewPosition INTO tblPositions FROM ReportA The second part confused me. What should go in place of Blah? Also, is the INNER JOIN joining the new tblPositions for each report that we just created...

Let's say the below example is from Report A, which shows 5 unique positions in the eyes of the Dept of Labor. Same job really but responsibilities/duties do vary from one level to the next. Accounting Associate I Accounting Associate II Accounting Associate III Accounting Associate IV...

That's the goal we're trying to get to, yes - whereas the new table consolidates the data from the 3 reports with one title for each position. (The reports have over 5,500 position titles listed.) Second step is to use that table to compare industry data (salaries, vacation, job level and...

We are consolidating multiple reports from outside vendors to evaluate our positions against industry standards. I'm having trouble matching position titles across the various reports to summarize the data. Example: Report A names a position "Business Development Rep" Report B refers to the...

I'm not familiar with Case Statements. How would I go about setting this up in the query design view of Access (2002)?

Info below shows which benefits an employee receives based on their status (full-time/part-time) and yearly hours worked. Benefits EE Status Hrs/Year 100% Full-Time Regular 2080 80% Part-Time Regular 1664-2028 70% Part-Time Regular...