Possible to hash a value in microsoft access?
Password hash function for Excel VBA
I tried running the following statement:  INSERT INTO VOUCHER (VOUCHER_NUMBER, BOOK_ID, DENOMINATION) SELECT (a.number, b.ID, b.DENOMINATION)  FROM temp_cheques a, BOOK b WHERE a.number BETWEEN b.START_NUMBER AND b.START_NUMBER+b.UNITS-1;   which, as I understand it, should insert into VOUCHER each record from temp_cheques with the ID and DENOMINATION fields corresponding to entries in the BOOK table (temp_cheques comes from a database backup, which I'm trying to recreate in a different format). However, when I run it, I get an error:  Error: Operand should contain 1 column(s) SQLState:  21000 ErrorCode: 1241   I'm running this in SQuirrel and have not had issues with any other queries. Is there something wrong with the syntax of my query?  EDIT:  The structure of BOOK is:  ID  int(11) START_NUMBER    int(11) UNITS   int(11) DENOMINATION    double(5,2)   The structure of temp_cheques is:  ID  int(11) number  varchar(20) What does ‘Sport’ mean when you say ‘the new Apple iPad sports cameras for video conferencing’? How can time dilation be symmetric? $\sum k! = 1! +2! +3! + \cdots + n!$ ,is there a generic formula for this? I came across a question where I needed to find the sum of the factorials of the first $n$ numbers. So I was wondering if there is any generic formula for this? Like there is a generic formula for the series: $$ 1 + 2 + 3 + 4 + \cdots + n = \frac{n(n+1)}{2} $$ or $$ 1^{2} + 2^{2} + 3^{2} + 4^{2} + \cdots + n^{2} = \frac{n(n+1)(2n + 1)}{6} $$  Is there is any formula for: $$ 1! +2! +3! + 4! + \cdots + n! $$ and $$ {1!}^2 +{2!}^2 +{3!}^2 + \cdots + {n!}^2 $$?  Thanks in advance. If not, is there any research on making this type of formula? Because I am interested. Messed up my PATH environment variable and can't login to desktop To get an maven environment variable to run, I tried several options. Basically, I followed some options from , such as ~/.pam_environment, /etc/bash.bashrc and I don't really know anymore. Within them I exported sth like export PATH=/opt/apache-maven-3.6.0/bin:$PATH (I'm being so unconcrete because I cannot look it up).   Afterwards, I did run gnome-session-quit and my machine got stuck.   So after hard restart I try to login again, but I'm not able to do that: I see my username, enter the password, hit enter, screen turns black and after 2 seconds I'm back at the login screen.   So, that very strange and worrying. Next step: Login via tty (Strg + ALT + F3). Within there I can login, but can not do much. I thought about sth like . But whatever I do: The command could not be located because '\bin' is not included in the PATH environment variable. I think, altogether thats alarming and I'm getting really nervous.  Executing export PATH="/usr/bin:$PATH seems to work and echo $PATHgives an output starting with /usr/bin:/usr/bin:/usr/bin:/home/user/Documents/.../esper/examples/transaction/etc:/home/user/anaconda3/bin:/usr/lib/jvm/java-1.8.0-openjdk-amd64/bin:/opt/apache-maven-3.6.0/bin:/opt/apache-maven-3.6.0/bin:/opt/apache-maven-3.6.0/bin but does not really help.  I'm running an Ubuntu 18.04 on an Lenovo G50-70.   Can you help me accessing my desktop again and/or fixing my PATH issue? I am trying to take pictures of large rugs. The rug size is about 10mx5m, and I'm  planning to purchase , and Canon 7D Mark II with Canon EF 50MM F/1.2L USM lens, since we need high quality images.  We want to set up a studio to take giga-pixel quality images of the large rugs for museum conservation purposes  Could you please suggest the best way for mounting the camera to the ceiling, and any other recommendations for my camera/lens setup, and required lighting? It will be  an indoor shoot. Just we want to setup a studio to shoot the large rugs. Background Video is shown in Rendered mode but not when szene is rendered i have a 3D Object and want to add a background image( if possible even a movie) to this 3D Object. I use Cycles to render and tried a plane with the  image as texture. When i go into render mode, it looks like this(picture with background) and when rendered, it has no background. The key also looks into  a different direction.  Should i even use Cycles for this or use motion tracking? i tried to use that but had several problems.     Rendered mode   When scene is rendered When is a biased estimator preferable to unbiased one? Choosing power supply, how to get the voltage and current ratings? make tail -f exit on a broken pipe I want to watch a file until a bit of text appears  I found this answer:   but when I tried it on ubuntu, it doesn't exit:  $ echo one &gt; test.txt $ echo two &gt;&gt; test.txt $ echo three &gt;&gt; test.txt $ echo four &gt;&gt; test.txt $ cat test.txt | sed '/w/ q' one two $   works as expected.  however when I try to tail the file  $ tail -f test.txt | sed '/w/ q' one two   it never exits.  tail does not stop even though the pipe is broken.  Does anybody know how to make tail exit when sed exits? This might seem like a very simple question, but what is the easiest way to turn a normal vertical list into a horizontal one? Is $|xy|$ differentiable in $(0,0)$? Is $f(x,y) = |xy|$ differentiable in $(0,0)$? I have no idea how to approach this problem. TP-Link Archer T3U Plus USB adapter Cannot make this wireless adapter work on Ubuntu 20.04... please help. I've tried this:  and now lsusb sees the device, but still doesn't work. lsusb: Bus 002 Device 006: ID 2357:0138 TP-Link 802.11ac NIC uname -r: 5.4.0-39-generic Edit: It works on my other computer with Ubuntu 18.04 using T2U Plus driver from here:  But it does not work with Ubuntu 20.04... sudo modprobe 88x2bu: Gives nothing. modinfo 88x2bu | grep -e version -e 0138 : version:        v5.6.1_30362.20181109_COEX20180928-6a6a srcversion:     9C5282368F93050B7206C8D parm:           rtw_chip_version:int  dmesg | grep 88x2 : [ 8087.334869] 88x2bu: loading out-of-tree module taints kernel. [ 8087.336610] 88x2bu: module verification failed: signature and/or required key missing - tainting kernel [ 8087.341389] usbcore: registered new interface driver rtl88x2bu Allow converting comments to answers Allow converting comments to answers, so they can become accepted answers.  I asked a question. Someone commented on it, and it was an awesome comment that fully answered the question. As the original questioner, I would like to convert that comment to an answer in order to accept it.  Or, if you prefer, I would be okay with being able to simply mark the comment as accepted. Multi-line list items on WinForms ListBox control? Is it possible that galaxies' redshift is caused by something else than the expansion of space? I was thinking that maybe photons loss energy naturally when they travel great distances.  Or maybe the mass of all matter is increasing over time and therefore photons emitted in the past are necessarily less energetic.  Or is the expansion of space backed up by so much other evidences that trying to find another explanation is completely foolish? Where does console output go As it is common with people from my country, I have an immense difficulty with prepositions in English, especially with the use of in and on.   When the preposition indicates the position of the object it is a bit easier to decide which one to use, but as it requires thinking from me, I still say things like "I put the bill in the fridge", "my pencil is on my bag", etc, even though if I think about it, I would know how to say it correctly.  Of course, even in those cases where the preposition indicates position the decision is not always clear, as is the case for example with "on the bus" (you are not on top of the bus, you are inside the bus) or "he is in bed" (you are not inside the bed, you are on top of your bed).  Other cases are even less clear, and I believe there is no real rule to decide what should be said; the person should just know it. Two examples are "in a bad mood", "you are on my mind".  So my first question is whether there is really no rule to help me. The second question refers to two of the cases where I still don't know whether to use in or on:   good luck on/in your exam in/on the list   The last one is especially important to me, as I have asked a number of native speakers, and each time I get a different answer. The only consensus seems to be the case where you say "on top of the list". Apart from that, some people will say that I should say "his name is in the list" whereas others think I should say "his name is on the list". And yeah, a couple of people did tell me that I can use either.  Can someone help me? Understanding how an ETF works I am trying to fully understand how ETFs work. For the sake of simplicity, let us restrict ourselves to physical replica ETFs. Let us suppose that an ETF follows an index which tracks three stocks: Alice Enterprises (A), Bob Industries (B) and Charlie's (C). We want to invest 1000$. The prices of each individual stock are 100$ (A), 10$ (B) and 1$ (C). The index weights at this moment are 60% (A), 30% (B), 10% (C). If I am not mistaken, when we buy a fund tracking this same index, the fund manager will automatically buy 600$ of A, 300$ of B and 100$ of C. Now, if we buy an ETF the underlying process is unclear to me. I understand the concepts of authorised participant and NAV spread. If A increases its value to 110$, authorised shareholders will first withdraw shares of A from the ETF and sell those shares, and then they will buy the ETF, pushing the ETF price upwards. This way the ETF price is automatically regulated and the authorised shareholders earn a profit. Everybody is happy. In contrast to a fund, when we buy an ETF we are not generally buying ETF shares from the ETF manager. Instead, we are buying ETF shares from another investor. Therefore... as I understand it, no new shares are really bought. And thus, following the process above, if we buy the ETF we push its price upwards. This again creates a &quot;gap&quot;, this time the price of the ETF is momentarily higher than its underlying assets and, therefore, authorised shareholders will sell ETF shares and buy shares of A, B and C. So... an ETF manager only buys a fixed amount of shares when the ETF is created? I want to know if I am correct in this reasoning about how the basics of physical ETFs work. I have tried to keep things as simple as possible. I understand that there will be lots of quirks and quincks, and it is great if these are elaborated in the answers. Availability of MXD file for OpenStreetMap data in Esri Geodatabase? From what I understand, an ArcGIS mxd file contains the "styling" information on how to show data.  I downloaded and imported OpenStreetMap data into my geodatabase. Now I need to show them.  Is there any available mxd file match the OpenStreetMap fields/values that I can use?  I check this question(), but the links are all dead.  ps: right now the all the highway/roads/trail display as a single line in my map. I want to use mxd to show them in a better way, like Mapnik or google.