Search results for query: *

Oops this is a french formula In english this must be =COUNT(MATCH(range1;range2;0) Hope this help ! -------------------------------------------------- Django [thumbsup] bug exterminator tips'n tricks addict

if you have 2 ranges in which you want to know how many cells are the same try the =NB(EQUIV(range1;range2;0)) confirm by ctl+enter to get a matricial formula -------------------------------------------------- Django [thumbsup] bug exterminator tips'n tricks addict

if you want to copy the formula of the first line in all the rows, you'd better put your formula in a name (ex 'calc') and change in the 1 line the formula's like this =calc to get the right formula select the first cell of the first line then record the code to change the formula via record...

the best is to use SQL server to make the queries and CR for the design of the Printing. In fact CR is not efficient if you have subqueries. In CR they are treated by subreports but they are very inefficient as they need a dialog with SQLServer to get each row. For instance essuming you have 3...

ViperPit, your locking logic is better but you still have the problem that the server is working with a list established before the orther servers have worked with the rest of the free clients. For this I think you have to end the loop and begin a new search for a a free client before...

Hi ViperPit, For me your logic seems a bit strange : First you check the clients to look for those to process, and get a list of them Then you lock all your clients to perform the task with only one, then you release all your clients and treat the next client It seems that the 19 other servers...

Here is my problem Thre is an app (ERP) running with sql server, connected with several sites. I want to give the users the ability to look at tables in the database without updating rights, and I think Access ùay be a good solution for this, with runtime and menus giving read-only forms. For...

I assume if you're on May 13th, you want the records from May 10th 00:00:00 to May 10th 23:59:59 So try : declare @startdate datetime declare @endDate datetime set @startDate= convert(datetime,convert(char,getdate(),101),101)-3 set @endDate=@startDate+1 SELECT ...,Date_Submitted FROM...

assuming as you said the format of the date like 'YYYY/MM/DD HH24:MI:SS' your query must be something like this if you want the records not earlier than 1/1/2004 : SELECT blah blah FROM blah blah WHERE .... and ("SHIPMENTS"."SHIPDATE" >= '2004/01/01') ORDER BY blah blah If you want...

It's unclear if the tblBoat table is the result of the tblAffects selection criterias. If this is the case, to get the results you want, you just have to do select ServiceID,Status from tblBoat where Boat=101 -------------------------------------------------- Django [thumbsup] bug...

THE BEST RESULT FOR SPEED IS NOT WITH A SUBQUERY? BUT WITH A JOIN SELECT custumer.id,name FROM custumer left join sales on custumer.id=sales.id where sales.id is null -------------------------------------------------- Django [thumbsup] bug exterminator tips'n tricks addict

maybe there a weird situation between the set statement WH_CRC1 = s.WH_CRC1, and the join clause d.WH_CRC1 <> s.WH_CRC1 both in the same query -------------------------------------------------- Django [thumbsup] bug exterminator tips'n tricks addict

You have a problem with the endPeriod calculation. If you write month/30/year what about february which has less than 30 days, and what with the months of 31 days? Furthermore what about the cbiper field? You need to convert it , maybe it's a string like yymmdd thet you can check like cbiper...

donutman's drawbackTable is a good solution but it needs, as in Shal2's sample, to completely know how the drawback is calculated, thet is, how are "exported" the different dutyChargedItems. eg in my sample above, the first export of 8 pieces will give one drawback record, and the second one of...

to use indexes avoid using them INSIDE formulas like you do in : Year({BT_MONTHLY_CUSTOMER.CALL_START_DATE}) change your selection this way (I try in pseudo_code as I haven't CR at the moment so check syntax and function spelling) ({BT_MONTHLY_CUSTOMER.CALL_START_DATE} >= totext({?Month})& '/...

If I Understand well you have 1- JKMT table which is loaded at the beginning by qties you received for different styles (barcoded) : Barcode dutypaid Qty Qtyremaining 20120603 1.2825 20 20 20120603 1.3012 33 33 20120610 1.2793 30 30 20120610 1.2994 56...

LBass means you have to create a formula field! But if you're in CR9 version you can simply go in the format field >>> general >>> in the bottom there is a 'text' button and enter in it the formula -------------------------------------------------- Django [thumbsup] bug exterminator...

For me you're not explaining clearly the problem You said : If you see the table1, for the same "style1" dutypaid value is different(3,1,2). I want to use up the highest paid first for the report. Let's say "Style1" "50" qty has been exported, for that I want to use "3" as duty paid first, then...

select s.id from emp s,emp1 s1 WHERE CONTAINS(emp.*, '"test"') and s.id=s1.id But why do you do a search on all he columns of emp. eg if you're searching in a descrption column only, it will be a lot quicker : select s.id from emp s,emp1 s1 WHERE CONTAINS(emp.description, '"test"') and...

Have you try this? select Id, Name, sum(case when (Date<'06/30/2004' and Date>'07/01/2003') then amount else 0) as thisYear, sum(case when (Date<'06/30/2003' and Date>'07/01/2002') then amount else 0) as lastYear, sum(case when (Date<'06/30/2002' and Date>'07/01/2001') then amount else 0) as...