Good to hear from you Jean. Yes, I can see the logic in that, but it then means I only need to put .t. as choose , ; instead of IIF(EMPTY(natno) OR ninoconfirm = .f.,.t.,.F.) as choose, ; in the field selection.
Working Sunday, HMRC has decided that the information in EVERY payrun has to be sent to them, before they just got the totals at the year end. So to stay with the big boys, I have to put in the hours! Kind regards Andrew Stirling 01250 874580 [email protected] http://www.calcpay.co.uk HMRC Accredited UK payroll program On 12/02/2012 14:29, Jean MAURICE wrote: > Andrew, I don not thonk that a where clause can work on a calculated field. So > the correct query is somthing like : > > > SELECT ; > IIF(EMPTY(natno) OR ninoconfirm = .f.,.t.,.F.) as choose, ; > natno, ; > ninoconfirm , ; > surname ; > FROM calcpay!employee ; > WHERE EMPTY(natno) OR ninoconfirm = .f.; > ORDER BY refn DESC ; > INTO CURSOR Empinfo READWRITE > > > Working on sunday ??!!! > > Best regards > The Foxil > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
