You are here:

  • Home
  • Computing/Technology

Computing/Technology

Recent Answers

2014-04-24 Using MS Access - Hi:

Try using a Subquery instead something like.    SELECT ICMS_PSTN.CUSTOMER_NUMBER, ICMS_PSTN.ACCOUNT_NUMBER, ICMS_PSTN.ACCOUNT_DESCRIPTION  FROM ICMS_PSTN LEFT JOIN SIEBEL_PSTN ON ICMS_PSTN.CUSTOMER_NUMBER

2014-04-23 Excel - calculating days between dates and subtracting a raw number:

The formula had been entered as an array formula (ctrl shift enter rather than just enter), which it didnít need to be Ė all formulas should be normal formulas in this case.  NOTE also that your use of

2014-04-23 Excel - datevalue:

Nahid,    when I put 18/3/2014 in a O3 as a string, then I put your formula in and check how the argument is being constructed,  I get     "14//2/18/3"    so you can see that you formula is not correct

2014-04-23 Excel - Exact formula:

with the data being in a1 to D6, and John being in row 5, the formula would be    =IF(OR(ISBLANK(B5),ISBLANK(C5)),"",B5=C5)    (I've given you the formula for this row, but obviously it can be extended

2014-04-23 Excel - Userform:

I guess all you can do is make the labels large enough so they display their text on all systems. One thing you can do is ask for the screen resolution of the person who does not see your labels properly

Categories

Browse Alphabetically

©2014 About.com. All rights reserved.