Search results

Probably use a Sum IF formula. Look at this example - then search on the Internet - there are many variations and examples. Be sure to post your best solution! Others are sure to thank you for it. https://www.extendoffice.com/documents/excel/1419-excel-count-sum-positive-negative-numbers.html

The question is: How to take this Cross-Tab of Sun's days (Calendar) and bring them into Columns of Earth's Year, Day calendar for the Value (X, ., *). The following is a daily log of the Sun's Geomagnetic Field as observed from Earth. Or, as Affected by Earth. For those of you who didn't know...

That is a better idea, use the web version of a spreadsheet. I seem to remember a post somewhere that we discussed how to connect a google doc into Access.

Access won't run on Apple. But the new small business Citrix would allow Access to run on just about any platform over the Internet. It is most likely more than a small coffee shop owner wants to do. For a POS, it would be possible to just enter data in a spreadsheet then send that...

The Pirate Part failed to take Icelandic Parliament. But, one might appreciate the effort and spirit! Computer hackers, programmers, unite! The Pirates, founded four years ago by a group of activists, anarchists and former hackers, tripled their share of the vote to 14.5%, and together with...

Any additional ideas on setting filters in an Excel Pivot Table? Also: Found TableRange2.Address - are there any other features for what seems to be an undocumented Excel object? The vba running from MSAccess to automate Excel objects: The...

This project also involved, filtering an area (in this case a Pivot) and copying the visible files over to another worksheet. Reminder: this is all remote automation from MSAccess to a newly created Excel workbook using object code. This problem did not occur when running the code from within...

Problem: Running the same .ActiveWorkbook.PivotCaches.Create a.k.a Create Pivot Table - in Excel vs MSAccess with remote automation: The Excel SourceData can be columns $A:$CC and run. From MSAccess using remote automation - it throws an OUT OF MEMORY error at the system level. Question: is...

Sorry it took so long to get back. After spending four hours to solve a simple problem, it turned out that it might help your question. Problem: Trying to insert a dataconnection in Excel to a make a worksheet linked. Using the Get Data using existing connections is well known. To do this with...

There are several ways to accomplish this. Be careful! using timers that spawn an object without closing the last object can be ... really bad. When TESTING - be sure to open Task Manager. If new instance of Excel are spawned every cycle, stop the session! The key words are below in some...

No, I can afford the full bike. Why is it people are impressed by more balls and less wheels? Things would be so much simpler if they wanted less balls and more wheels Until I saw a video on you tube of this guy riding down a set of stairs, so I just had to try it. I broke my neck before...

The fun part of the Europa deep oceans with high oxygen content and possibility of life being constant for over 100 million years is how things might evolve. Is evolution a result of normal but massive climatic change (including meteorites, volcano, and air-conditioning)? Or, would dinosaurs...

I think the term is Invasive Species? We all have our pet real-world personal experience of villains of conservation biology disrupting ecosystem and throwing native populations into disarray. The English Sparrow in the US Midwest, burrows on islands, Russian Tumbleweed in North America...

Was considering sending the Pirate Party in Iceland a $10 USD donation. Wondering what kind of blowback our own government might have when they ID me as some classification or another? Heck, maybe I will just fly there in May 2017 and buy the Tshirt. Assuming travel is permitted after our...

You bring up a good point. It is actually 2 1/2 D with the brain filling in the rest. A true monitor on a coffee table would let people sitting in a circle around it all see the perspective angle of a 3D image. So far, that kind of projector has not seemed to been announded.

Iceland’s Pirates head for power on wave of public anger Story: http://uk.reuters.com/article/uk-iceland-election-idUKKCN11Z1RV The Pirate Party has found a formula that has eluded many anti-establishment groups across Europe. It has tempered polarising policies like looser copyright...

Once upon a time, a man appear Once upon a time, a man appeared in a village and announced to the villagers that he would buy monkeys for $5 each. The villagers, knowing there were many monkeys, went to the forest and started catching them. The man bought thousands at $5 each and, as supply...

This Access club has a great site where a presentation and code can be posted for those who can't make it. The Microsoft sponsor also has the ability for live video streaming, and video archive. In general: if just 8 others would request the presentation be available for video later, I feel...

Since video games need a monitor, what will the future hold? The computers and graphics cards are now so powerful, many say an i7 fifth generation can never really use all of its resources. But, what about Monitors? Years ago, I spent a lot so my primary computer has two 32" way beyond 1080i...

Re: no sunlight Europa, NASA revealed new evidence for water geysers shooting from the ice-covered satellite. (e.g. volcanic activity) http://www.bbc.co.uk/nature/habitats/Hydrothermal_vent It appears that the Earth had at least twice frozen over, ice over a mile deep at the equator. Life...