Search results for query: *

Sorry about the delay in getting back: The data format for the Statitem field is year.weeknumber, eg 2002.01. The statitem table is updated once a week and is a summary table from a daily transactional table that receives data from a number of sites (in this case sales data). So basically...

Sorry about that 'Vamp, Am using Crystal 9 through an ODBC connections to an MSSQL 2000 DB. The 'Statitem' field is a VarChar 9 character data field. cheers B

Hello Gurus, I have a perplexing little formula to write that I am at a roadblock with. I am constructing a report where I need to provide the sales figures for a definable week (easy part) as well as column for each of the past 13 weeks sales.... plus another column for the current Financial...

Hi Sonof.... Thanks for the refinement. I made just 1 subtle change (adding the distinct to the initial select podetail.lintitemnumber, and it was EXACTLY what I was after. many thanks to you for your reply. P.S thanks to Transcend too for your input. SELECT DISTINCT...

Hi All, I am (attempting to) write a select query where I want to return distinct rows based on a max/distinct criteria. please see the below query for my WIP thus far: select lintitemnumber as IPN, curcost as CurCost, dtmwhen as CurCostDate from podetail pod where dtmwhen = (select...