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...
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...
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...
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...
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...
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 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
i am using fireworks cs5.
previously I have used fireworks 8.
These are the problems I am encountering.
I am creating a logo. I am using the eclipse tool to draw a perfect circle.
I am using text tool to write logo name. I then attach the text to the eclipse tool. Now problems occur.
For...
Fireworks 8.
Appologies as I could not find a fireworks 8 forum on this site.
On fireworks 8,
How do I get text to stay on one line? Sometimes no matter what I do the text does not stay on one line but there is a carriage return.
Thank you
I have created Microsoft powerpoint using 2010.
I have speaker notes. I want to print the speaker notes to pdf.
So thus I go to view tab --> then choose Notes pages
then file --> print --> [choose pdf]
however it does not print the speaker notes.
Why?????
How can I print speaker notes to pdf...
Apologies, I put this original message in the wrong subject area.
I am using MS Access 2010 and have normalised the table via
Database tools --> analyze table and split a large table into smaller tables. The problem is I accidently put the title field into product table.
I have taken off the...
MS Access pivot tables.
I am new to MS Access pivot tables. How do I create bar charts in MS Access to show data of how many sales?
Thank you in advance
Hi I have created a database and it will hold clients name and address including postcode. I wish to put an Input Mask for the postcode. By default the postcode for MS Access is
>LL0 0LL
MS Access writes "every postcode follows the above format". For example Cambridgeshire CB4 2XC, Hampshire...
Hello I am using excel 2010.when I write a comment it starts with the owner. I want to change this. When I write a comment on an excel cell I want it to start with the authors name or start with a blank comment. How can I make this happen?
My project involves working with excel and writing many...
I created a really good flash presentation on Flash CS4. I optimised the animation by going to File/publish setting/ then flash tab I reduced the flash player to 8 and I think to Action Script 2. I opened the flash today and found lot of my flash animation has been lost.
Please help how do I...
I have wifi router network at my house. I have a long garden and at the end of the garden their is a summer house which I often use. I have an Toshiba and HP laptop both laptops have excellent signal at home. However when I am in the garden my Toshiba laptops does not always give the best...
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.