What is the correct CASE SELECT Statement in Access 2010?
Case expressions in Access
How do you convert a cake recipe to make brownies? Can you explain the sentence structure 'In a hole in the ground there lived a Hobbit'? Why put the verb before the subject? The opening sentence to The Hobbit by J.R.R. Tolkien reads,     In a hole in the ground there lived [verb] a hobbit [subject].   I wonder if there are accepted stylistic purposes for such a structure.  When is it natural, and when is it unnatural? VirtualBox Toolbar is hidden! How to show it? A finite sum involving the binomial coefficients and the harmonic numbers Wikipedia has a proof of the identity $$ H_{n} =\sum_{k=1}^{n} (-1)^{k-1} \binom{n}{k} \frac{1}{k}$$    Curiously, there is also the identity  $$ \frac{1}{n} = \sum_{k=1}^{n} (-1)^{k-1} \binom{n}{k} H_{k} $$  Can the second identity be derived from the first one? Why upload to academic preprint sites like arXiv? The recent question  made me realize that I don't have any understanding of why one would upload to a preprint site.  (I don't work in a field where they seem to be common.)  Why would one be concerned about getting a manuscript on arXiv, if it's already under review with a journal?   Is it because of the long publishing timeline of journals?  (That could explain why computer science &mdash; which publishes much more in conferences &mdash; doesn't seem to do much with them.) What Nikon lens for both macro and portrait? All three lenses are available at a local store near me:   85mm 1.8 at about 400USD  85mm 1.4 at about 1000USD 105mm 2.8 at about 1015 USD   I plan on doing macro and portrait photography and have the ff thoughts so far:   I can save a lot with the 85mm 1.8 and a site claims that AF-wise it is much faster than the 85mm 1.4 at twice the price 105mm has VR but I don't know if that would be of much use with portrait and macro as I usually don't use slow shutter speeds with such subjects 105mm has AF-S which means I can get better insect shots because of the silence( and the 105 mm range) I don't know why I should prefer the 85mm 1.4 over the 105mm, when the 85mm may only have AF speed as an advantage, though I am not so sure if it is faster   so as you can see, I'm leaning towards 105mm f/2.8 or 85mm f/1.8 and less towards the 85mm f/1.4. However, I don't want to finalize the decision as many also claims that the 85mm f/1.4 is so good.  Any professional insights to add in helping me make the decision? change folder icons in ubuntu-mono-dark theme How to split one string into multiple strings separated by at least one space in bash shell? I have an external hard drive and I did something which I shouldn't have done, and I am annoyed that many files are prompting me about Administrator permissions to move a folder.  They are regular files.  How do I reset all the permission on the external hard drive? Is it true that: $a+bi$ is prime in $\mathbb{Z}[i]$ if and only if $a^2+b^2$ is prime in $\mathbb{Z}$ How do i make my ubuntu server public? I want to know how to make my ubuntu server ip public. I'm not asking for a domain, if people would be able to access my website by ip, it would be great! (just for now) Does someone have an idea how to do this? No space following macro without argument Bread and butter is/are my breakfast? Bread and butter (is or are) my breakfast?  And what's the difference between the above sentence and saying "My breakfast is bread and butter"?  Thanks. msbuild, defining Conditional Compilation Symbols I'm possibly just blind, but is there a command line to specify conditional compilation symbols in MSBUILD?  I currently have this Line in my buildscript:  SET MSBUILD=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\MSBuild.exe SET CONFIG=Debug %MSBUILD% /p:Configuration=%CONFIG% /p:OutputPath=..\..\output source\MyProject\MyProject.csproj   And I'd like to add a condition. In Visual Studio, i can just go into Project Properties => Build => Conditional compilation symbols, but I have not seen that option for msbuild?  Bonus Karma if you know if I can completely override all symbols already specified in the .csproj files to make sure that only the conditionals from my Buildscript go in. Spoilers for the end of the second film      Towards the end of the fight against Ego, we see that the bomb Groot set off blows up Ego's core. Shortly thereafter, it cuts to a scene where Quill is shown apparently losing his powers.   Given that the movie builds up this finale so much, I'm left wondering:      Did Quill lose his powers or merely the means to access them after Ego's apparent death?   Answers from the film or comics are very much welcome. Position of a relative clause before/after a verb I'm not sure about the sentence structure below:  All kinds of problems arise that smaller animals or plants do not have to cope with.  It looks like that works as a relative pronoun for all kinds of problems, but I couldn't find such usage in my dictionary or online. This sentence could be divided into  There are all kinds of problems. Smaller animals or plants do not have to cope with all kinds of problems.  But, I can't figure out where 'arise' fits. If you have any thoughts, please share them. Changing wp login url without .htaccess How to change wordpress login url without using .htaccess, should be a manual process, so example.com/login will not redirect to example.com/wp-login.php so example.com/login will be the login page? In my assignment I have to prove that the following function doesn't have a limit:  $$f(x)=\frac{x}{x-\lfloor{\sin x}\rfloor}$$ when $${x \to 0}$$  In other words, I have to prove that for every $\delta$ such that $0&lt;|x-{x_0}|&lt;\delta,$ $|f(x)-L|&gt;\epsilon$.  In fact, I don't even know how to start. Do I choose my $\delta$? I know that the sin function has certain values that's supposed to help me. How do I use it?  I have to prove this by definition, so I can't use limit arithmetic for example  Thanks. How to position the paper's authors' addresses on the front page (maketitle)? When I use the following code for the title page of a paper (please see below), the authors' addresses and emails appear on the last page of the paper. However I need them to appear on the first-title page (after the authors' names before the abstract). How can I do this?  \documentclass [reqno, 12pt ]{amsart} ... \begin{document}  \title[paper]{Nice paper}  \author{Me} \address{University} \email{mmm@lala.com} \thanks{.} \author{my friend} \address{Institute} \email{kkk@lala.edu} \thanks{.}  \date{\today} \keywords{XXX }  \begin{abstract} Lalala \end{abstract}  \maketitle Let's say I want a way to display just the the center 50x50px of an image that's 250x250px in HTML. How can I do that. Also, is there a way to do this for css:url() references?  I'm aware of clip in CSS, but that seems to only work when used with absolute positioning.