Novice to SQL need to help with coding
I have a population table and I want search the countries that are big by area or big by population.
select name, population, area from worldwhere population >250000000 or area > 3000000
The above SQL code does this, however I only wish to Show the...
I have a column lets call it A, in column A there is 9 random letters A to I e.g.
I
E
D
H
F
A
c
B
G
in column B I wish to have numbers that match the random letters from column A, e.g. A = 1, B = 2,
How can I do this?
I am editing a MS PowerPoint emailed to me from a Chinese friend. When I type text in the text box it does not start a long word on new line and this causes problems. If I were to use a new PowerPoint (MS PowerPoint 2010, so not the one given to me by Chinese friend) for example if I write "My...
I mean the drop down, in Excel this is created with data validation
when i click the drop down Medical cost 1 Medivet it works but when i change the drop down to Medical 2 Confused.com or Medical 3 Angel Dog Medics it gives N/A error.
please help
Why does my spreadsheet say N/A error when I click on the data validation for medical cost:
Medical cost
Medical cost 1 Medivet
Medical 2 Confused.com
Medical 3 Angel Dog Medics
On the animals spreadsheet the data validation wroks for Medical cost 1 Medivet but when i change the data validation...
=IF(AND(C6>110,C6<844),IF(C6>844,C6*0.11+(C6-844)*0.01,C6*0.11),0)
I tried Zelgars formula,
there is something wrong with the logic, for example on values about 844 it returns 0.
what is wrong with it?
I am carrying out a Microsoft Excel exercise. It is for National Insurance.
The current national insurance rate ranges in the following manner; If you earn more than £110 a week and up to £844 a week, you pay 11 per cent of the amount you earn between £110 and £844. If you earn more than £844 a...
what about if it is projected to show a room layout?
Think really hard about this...
or just get a projector, draw the layout of the room and proof it to yourself!!!
I have drawn the layout of my room in Excel, so excel cells are different furniture in my room. I use a projector to display the room, on the projector the layout is fine, however when I print it out, the left and right are on the opposite side. Imagine when you ask the question "is it to my...
>Undo via the history panel or restore from backup
cannot undo from history panel
> or restore from backup
I have no backup
>Is the mode set to greyscale?
I think I must have done this! I have very clumsy hands, and do lots of projects at once, and use lots of different software at once...
I am using Photoshop Cs5. I am creating a poster and my poster has turned black and white. When i look in the channels my red, greem and blue channels have gone!. How can I get it back? Thank you in advance.
I am using Microsoft Excel 2010. When I enter comments it has my name on the comment 47redlands, when I click off, or go to safe the spread sheet, or go back to excel after saving, the comments on 47redlands changes to Author. How do I keep it so the name on the comments stays 47redlands? I have...
mikrom - this is amazing book, it is something i have been looking out for a very long time I will be reading this straight away! Again a big thank you for directing me to this!
I wish to teach Java programming to my young nephew. He wishes to go straight into game developing.
Is there any open source/shareware java games with graphics front end? I want the game to have graphical front end from the start so all I teach my nephew is game logic via “if statement”...
I have solved the problem or it fixed itself.
It could be one of those ICT problems I do not understand I call these computer gremlins.
Anyway remote working is working on Chrome.
I work remotely from home sometimes and I use Citrix client.
I have just purchased a new laptop and it has windows 8 installed.
I have tried to install CitrixOnlinePluginWeb and CitrixOnlinePluginFULL
both fail and I do not know what to do:
Citrix online plugin application
There is a...
I am using MS Access. I have created a MS Access query.
The query returned about 60 records
I want to only examine about 15 results at a time.
How can I change my query to do?
Thank you in advance
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.