Recent content by HRISmess

Think I figured it out -- d@mn syntax. A lack of parentheses were the main culprits; replacing '' with ""; and reformatting date was also necessary. Thanks! QUERY: select Count(*) As EECOUNT from e_history_job j where ((((j.empl_rcd_nbr) = 0) and (j.empl_status) in ("A","L") and...

I have the following query that counts all employees in a specific status, before a specific date. I need to modify with appropriate syntax in Access...what tweaks am I required to make here? Or, is there a more simplistic way to capture the data? Any help is appreciated! Cheers! Query...

One more question on the topic: If I had to target a particular PersonnelAction that had Multiple Rows of data, how would the query change? For instance: EMPLOYEEID P_Action P_ActionDt EFFSEQ 123456789 TER 12/31/2006 0 123456789 TER 12/31/2006 1 123456789 MPR 1/1/2007 1 123456789 MPR 1/1/2007...

You guys are the best. As always, thank you for making my work life a little brighter!

I have some queries written in Oracle SQL that I need to jam into an Access Design grid - long story - and need some help. Essentially, I have a table with Employee personnel transactions and need a query that can identify the last of those transactions on any given day. So, I know I need a...

The query below identifies the last day an employee is in an EMPL_STATUS of (A or L). I need to now count all employees that were active as of monthend for each month of 2006...and I am stuck! Do I run a separate query to identify all EEs who have termed and their effective date; then, compare...

I have a user form that I have created a field named "Transaction Number" for, which is not the primary key for the table used to build the form. I need to accomplish the following: 1) Create an indexed value with no duplicates in the "Transaction Number" field, that can update itself...

lunchtime bump

I have a user form that I have created a field named "Transaction Number" for, which is not the primary key for the table used to build the form. I need to accomplish the following: 1) Create an indexed value with no duplicates in the "Transaction Number" field, that can update itself...

bump

I appreciate the feedback. I wonder if adding the Where clause will limit output to only those with a Maximum effective Date than the 6/1/2005 example cited above? I'll try it and see where that gets me.

EMPLID EFFDT EMPL_STATUS JOBCODE 1111 1/1/05 A BAS 1111 1/1/04 L AOK 1111 1/1/06 A SAD Right now my query identifies the last row as the maximum effective date. What I am trying to answer is a a question such as: Identify the following...

I am in the process of doing some point in time reporting and am having difficulty identifying all the data on row 'As of' a specific date. For instance, I need to identify an Employee's status As of a specific date. The query below identifies the maximum effective date and corresponding...