Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: 47redlands
  • Order by date
  1. 47redlands

    Novice to SQL ,, need helpt to exclude some rows

    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 world where population >250000000 or area > 3000000 The above SQL code does this, however I only wish to Show the...
  2. 47redlands

    how to match random letters to numbers

    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?
  3. 47redlands

    PowerPoint problems, long words are broken up in text box

    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...
  4. 47redlands

    spreadsheet say N/A error when I click on the data validation

    Thank you, Understand what is happening. Thank you
  5. 47redlands

    spreadsheet say N/A error when I click on the data validation

    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
  6. 47redlands

    spreadsheet say N/A error when I click on the data validation

    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...
  7. 47redlands

    Formula is not behaving as i wish it to do

    =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?
  8. 47redlands

    Formula is not behaving as i wish it to do

    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...
  9. 47redlands

    Mircosoft Excel, printing solution

    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!!!
  10. 47redlands

    Mircosoft Excel, printing solution

    I have setup the room to be projected. If you have a projector you will notice what i am talking about
  11. 47redlands

    Mircosoft Excel, printing solution

    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...
  12. 47redlands

    photoshop picture has turned black and white

    >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...
  13. 47redlands

    photoshop picture has turned black and white

    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.
  14. 47redlands

    change name on comments, not working as it is supposed to.

    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...
  15. 47redlands

    learning to program java with games

    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!
  16. 47redlands

    learning to program java with games

    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”...
  17. 47redlands

    windows 8 CitrixOnlinePluginWeb is not working

    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.
  18. 47redlands

    windows 8 CitrixOnlinePluginWeb is not working

    I have been on the citrix website that is when I downloaded the full version but I am still experiencing problem
  19. 47redlands

    windows 8 CitrixOnlinePluginWeb is not working

    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...
  20. 47redlands

    MS Access query returns 60 records I wish to change so it returns only 15 results at a time.

    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

Part and Inventory Search

Back
Top