TechRepublic Resources
- Find Values From Range Sum Of Which Is Nearest To Target Value
- PLS. anybody who can help me? I'm looking for the solution of such a problem:I have a range of numbers in the column (for example 7) and a target valueNumbes Target 10.33 4261913No one combination of sum of numbers makes this target value.But I don't need to get the exact...
- Tags: Value at Risk, programming, vba, agrebeschuk@...
- Discussion threads 2006-12-11
- Find Values From Range Sum Of Which Is Nearest To Target Value
- PLS. anybody who can help me? I'm looking for the solution of such a problem:I have a range of numbers in the column (for example 7) and a target valueNumbes Target 10.33 4261913No one combination of sum of numbers makes this target value.But I don't need to get the exact...
- Tags: Value at Risk, programming, vba, agrebeschuk@...
- Discussion threads 2006-12-11
- Find Values From Range Sum Of Which Is Nearest To Target Value
- PLS. anybody who can help me? I'm looking for the solution of such a problem:I have a range of numbers in the column (for example 7) and a target valueNumbes Target 10.33 4261913No one combination of sum of numbers makes this target value.But I don't need to get the exact...
- Tags: Value at Risk, programming, vba, agrebeschuk@...
- Discussion threads 2006-12-11
- Find Values From Range Sum Of Which Is Nearest To Target Value
- PLS. anybody who can help me? I'm looking for the solution of such a problem:I have a range of numbers in the column (for example 7) and a target valueNumbes Target 10.33 4261913No one combination of sum of numbers makes this target value.But I don't need to get the exact...
- Tags: Value at Risk, programming, vba, agrebeschuk@...
- Discussion threads 2006-12-11
- Find Values From Range Sum Of Which Is Nearest To Target Value
- PLS. anybody who can help me? I'm looking for the solution of such a problem:I have a range of numbers in the column (for example 7) and a target valueNumbes Target 10.33 4261913No one combination of sum of numbers makes this target value.But I don't need to get the exact...
- Tags: Value at Risk, programming, agrebeschuk@...
- Discussion threads 2006-12-08
- How do I... Generate a running total in an Access query?
- This article is also available as a PDF download.Displaying subtotals, grand totals, and otherwisesummarizing data is a common report feature. You can display a running total ina report simply by setting a property. A runningtotal is a cumulative sum that evaluates the previous rows and the currentrow. In other words,...
- Tags: Displaying, Microsoft Access, SQL, Susan Harkins, Value at Risk
- Technical articles 2006-12-04
- Understand the effects of NULLs on inner and outer JOINs
- For reader clarificationFor reader clarification, the reason you cannot join the value 1 with the value NULL is becuase the value NULL is unknown. You, and the system for that matter, will not know the value NULL until an explicit value is entered
- Tags: tim chapman, Value at Risk, software, NULL, NULL VALUE, NULLS, chapman.tim@..., foreign key
- Discussion threads 2006-11-28
- Learn the basics about C# data types' variables
- The ability to work with any programming language requires agood understanding of the data types it offers in order to comprehend thelanguage's possibilities and limitations. In this article, I look at thecharacteristics and specifics of C# data types as a way for developers to havea better grasp of what the...
- Tags: C#, integer, Irina Medvinskaya, Software engineering/development, Value at Risk
- Technical articles 2006-11-20
- MS Access: Calculating a fields value
- I have an inventory database that I wish to retain actual count of items on hand. The value will change each time an item is pulled from the inventory so, is the present value (PV) is 10 and I use (UV) 2 a calculation of (PV-US)would give me the...
- Tags: programming, Value at Risk, access, software, wefraz@..., Microsoft Corp., Microsoft Access
- Discussion threads 2006-11-15
- 10 tips for working with dates in Microsoft Access
- This article is also available as a PDF download.Working with dates in Access can be somewhat confusing. Fortunately,Access offers the Date/Time data type, which greatly simplifies the job ofhandling dates. In addition, you'll find a number of functions that manipulatedate values and components. But even with all the built-in help,...
- Tags: Calculating Julian, Ctrl, current date, Microsoft Access, Microsoft Corp., Susan Harkins, Value at Risk
- Technical articles 2006-11-13
- Work with multiple data values with arrays
- Arrays are a basic feature of most development languages. Arraysare mechanisms that allow you to treat several items as a single collection andto easily work with multiple data values. The .NET Framework provides arraysupport in a variety of ways. In this article, I examine the basics of usingarrays to work...
- Tags: C#, Microsoft Visual Basic.Net, Tony Patton, Value at Risk
- Technical articles 2006-10-17
- 10 tricks for handling null values in Microsoft Access
- This article is also available as a PDF download.Where errors are concerned, null values are an equal-opportunitymenace. If an unhandled null value doesn't generate a runtime error, it'll showup in erroneous data. Neither problem is your run of the mill "oops, there's abug" error. In fact, an unhandled null value...
- Tags: IS NULL, IsNull, Microsoft Access, Microsoft Corp., Susan Harkins, Value at Risk
- Technical articles 2006-10-12
- Creating a form to append a table with values from other tables/data entry
- Hi,I have built an Access DB containing 3 tables: dimensions, time, companies. The tables are not linked and are to be used to look up values for the new form. The goal is to create an Access form that would allow the user to select distinct values
- Tags: access forms to append table, main table, programming, software, Value at Risk, zima8172@...
- Discussion threads 2006-10-12
- Stupid Active Directory Question
- How the heck do I get a list of the *active* users in Active Directory? It seems like the simplest of requests, but I can not find any information about how to do it (though I did read somewhere that you *can't* do it?!). Help!define activeDo you mean...
- Tags: active directory, domain, domain controller, Menace65, queries, server, software, Value at Risk, windows
- Discussion threads 2006-10-11
- Using Oracle's COALESCE function as a quick CASE statement
- DB2This functionality is not limited to Oracle, exists in DB2 SQL as well.....Quite rightThanks for commenting! You're quite right: it's part of the SQL standard. The title of the article was not meant to imply it was an Oracle-specific feature.BobWLooks like Decode to meThis looks almost exactly like Decode to...
- Tags: algorithm, COALESCE, Decode, Oracle Corp., ProblemSolverSolutionSeeker, software, sql, Value at Risk
- Discussion threads 2006-09-27
- Internet Options tabs have gone
- Not sure what or when things went wrong, but there are only 2 tabs left on my Internet Options; Security and Privacy. All the others have disappeared for some reason. I need fix this because some Active X files need to run but I have no way adjusting and settings...
- Tags: Internet, Internet Options, ken@..., Microsoft Internet Explorer, registry, Value at Risk, windows
- Q&A 2006-08-23
- Runtime error 35761
- Hi I am getting Runtime error 35761 very frequent during download, thedownload stop after sometimes and the 'Runtime error 35761 ' pop-upappeared. I search the web for an answer in one article it say toincrease the timeout value. In my router NAT setting, there are itemslisted which one should I...
- Tags: Runtime error 35761, Value at Risk, wahchee2001@...
- Q&A 2006-08-15
- Save time and prevent coding headaches with nullable types in C-sharp 2.0
- Oneheadache for C# developers before C#2.0 was the inability to assign a null value to certain types. Forinstance, if you declared an int, you could never set that variable to a null value. Thesame held true for DateTimeobjects. This limitation forced application developers to come up with their own solutionsand...
- Tags: GetValueOrDefault, HasValue, nullable type, Value at Risk, Zach Smith
- Technical articles 2006-08-03
- Working with dates and times in VB.NET
- wish it was more informativethe article states "return the month component". Well, what is it that is returned? a name in english or a numeral in the range 1 to 12 ?Also, article makes no mention that when using a variable of type DateTime and displaying its value...
- Tags: Value at Risk, arzewski@..., date, programming, Microsoft Visual Basic.Net
- Discussion threads 2006-06-30
- Compiler Optimizations Can Only Go So Far
- My most recent post ("How I Improved Execution Speed By 100 Times In 5 Minutes") generated some tremendous feedback. One of the things that was touched upon a number of times was the possibility of the compiler or managed code environment caching values used in loops, or automagically transferring the...
- Tags: compiler, Kevmeister, loop, Value at Risk
- Blog posts 2006-06-30
