Recent content by Salwa

ok thanks

is a field in AbsenteeismTable that i need to add to the Sum(AbsenteeismTable.TAKEN to end up with a balance.

I have the following query SELECT COSTCENTRES.GROUP, Corp1.COSTCENTRE, COSTCENTRES.RESP_DESC, AbsenteeismTable.EMP_ID, AbsenteeismTable.NAME, Corp1.GRADE_DESC, Corp1.EMPLOYMENT, Sum(AbsenteeismTable.TAKEN) AS SumOfTAKEN FROM (Corp1 INNER JOIN COSTCENTRES ON Corp1.COSTCENTRE =...

i get the following message with your modified query. At most one record can be returned by this subquery.

at the moment 1, as I have doctored the data

I am BA not a coder and I have limited experience with MS Access. So unsure how to do what you are saying.

no, it is a different value to that of the one in the main query. the Code value in the main query is either A654 or A655 and the code value in the subquery is either A630 or A636.

Hi How do I get the subquery T1.CODE value to be displayed as part of the main query? Thanks heaps SELECT CopyTIMEENTRY.TCT, tblPayrollOfficers.TCTNAME, CopyTIMEENTRY.EMP_ID, CopyTIMEENTRY.NAME, CopyTIMEENTRY.TRANSDATE, CopyTIMEENTRY.CODE FROM tblPayrollOfficers INNER JOIN CopyTIMEENTRY ON...

Thanks for the prompt response. I am BA trawling through SQL queries and VBA code to reverse engineer requirements. I was unclear as to how you can change the sort condition midway through. How would it work for the following? EMP_ID DATE_HIRE ETPSTARTDATE EMP_STATUS 21214 24/11/2008...

I came across the following syntax in a query ORDER BY TEST.EMP_ID, IIf(IsNull([ETPSTARTDATE]),[DATE_HIRE],[ETPSTARTDATE]); Appreciate if someone can explain to me how this works, with examples. I was unaware that you could do this. Thanks heaps sample data EMP_ID DATE_HIRE ETPSTARTDATE...

Thanks all for your prompt responses. June7 provided the answer. I found the procedure with the relevant information.

Hi all. Appreciate if someone can tell what the following syntax in a SQl statement is doing and how it actually works...