Search results

Hmmmmmmmmmm... Yes -logy / -ology is a suffix, and I'm wondering if the root for it is "zoo" or "zo"

Sorry, should have clarified that I meant "oo" words where the "oo" was multisyllabic. Fair example, but I think prefixes are special exceptions for pronunciation, particularly for those prefixes that end in a vowel and can come before a root word which starts with a vowel. e.g. Coaxial...

The last forum I frequented that had a "Debates" section called it "Politics, Policy, and Religion", (PPR for short) because that will pretty much cover most debates people would have.

I think the progression would be something like this... Thing: Anything - Something - Nothing Body: Anybody - Somebody - Nobody One: Anyone - Someone - No one I believe the explanation would simply be that it's a non-standard spelling convention, possibly to avoid mispronunciation in written...

If I'm not mistaken, when Access creates a table based on a query, it automatically attempts to guess at the required data type. Sometimes (read: quite often), it's wrong.

Hmm, I understand your problem, but don't know enough about Make Table queries to suggest a solution (can you set decimal precision?) (I no longer use Access, but I spend most of my work days writing SQL). I don't suppose changing the "fieldX/fieldY AS calcPercentage" to "CDbl(fieldX/fieldY)...

Considering the simplicity of the calculation, is there any reason you can't store the 2 base values in your temp table, and dividing them when you query it later?

There WHERE clause was never in question. If the fields for NHD_Name and NHD_Email are blank, then your JOIN criterion is not matching. Ensure that you have a matching NHD_SAP_ID row in your tbl_NHD and that it corresponds to the NHD_SAP_ID in tbl_Session.

What are your results running the following? SELECT tbl_Session.*, tbl_NHD.NHD_Name, tbl_NHD.NHD_Email FROM (tbl_Session LEFT JOIN tbl_NHD ON tbl_Session.NHD_SAP_ID = tbl_NHD.NHD_SAP_ID) WHERE tbl_Session.Status_ID=3;

When you run it with the INNER JOIN tbl_NHD, does it give you an error, or simply 0 results? Shot in the dark, can you run it with LEFT JOIN tbl_NHD and let us know the results? EDIT: It's possible that you have different data types in the tbl_Session table and the tbl_NHD table for the field...

As I mentioned before; I don't think Excel supports that second level of abstraction when it comes to evaluating a cell, then evaluating the whole function above that with the value of the first. At least, not automatically. If you are up for a bit of manual work, you can set the formula cell...

I'll write up some VBA when I get home, unless someone else beats me to it. Am I correct in assuming that you're running the SUMPRODUCT formula on one cell (F2)?

I'm not sure that Excel supports that level of abstraction in the cells, but you can certainly query another spreadsheet through VBA. I'd define a new Excel.Application, open the target workbook (pull the data from the spreadsheet's cells), and grab the range you're looking for (could also pull...

Digital theft rarely takes the metaphorical form of storming the doors and kicking things over. It's usually done over the course of a couple of days or weeks, and with small enough changes that they aren't easily detected. e.g. Last time I initialized an unauthorized forcible copy of a user...

There are 4 major int'l consulting companies that consume a HUGE portion of H1-B Visas: Infosys, Wipro, Cognizant, Tata Consultancy (I used to work at one of these). The system is largely abused by large companies (namely, these 4) and it's quite difficult for any other companies to acquire...

I realized that I never clarified who that was when I posted. My daughter would be the infant who is out of the frame to the left. My wife and I are 25.

The auto-insert signature is stored in the hidden Word bookmark called _MailAutoSig Sub DeleteSig(msg As Outlook.MailItem) Dim objDoc As Word.Document Dim objBkm As Word.Bookmark On Error Resume Next Set objDoc = msg.GetInspector.WordEditor Set objBkm =...

Hmm, you know, considering the wonderful community here, and the wealth of knowledge everyone has regarding Access, database design, query design and optimization, I'm surprised the Web Design section of the forums is so dead. I do most of my work in PHP and MySQL, and even at work, I use shell...

When we ordered it, we had no idea it would be so large. I believe her sides were a house salad and green beans. There was a knife, but it wasn't pictured. The steak flavour actually came through quite well. The taste was pretty good, though a bit salty (lots of sodium in the breading and the...

Well, I went out for dinner tonight with my wife and daughter, and thought I'd provide some insight into the portions. Restaurant: Texas Roadhouse Menu: Displaying their steak sizes and prices "Country Fried Sirloin": Sirloin steak breaded and deep fried, then topped with gravy.