1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hi Guest, welcome to the TES Community!

    Connect with like-minded professionals and have your say on the issues that matter to you.

    Don't forget to look at the how to guide.

    Dismiss Notice

Cambridge Exam Paper 2 May/June 2007

Discussion in 'Computing and ICT' started by CaseBusy, Sep 15, 2011.

  1. CaseBusy

    CaseBusy New commenter

    stuck on Q44:
    Q44 Produce a report which:
    <font size="3" face="TT288o00">
    </font>
    if i put Like "Biro*" it will give me a query that will list all the biros with different colours.
    What do i type in to just get biro and blue?

    Cheers!


     
  2. CaseBusy

    CaseBusy New commenter

    stuck on Q44:
    Q44 Produce a report which:
    <font size="3" face="TT288o00">
    </font>
    if i put Like "Biro*" it will give me a query that will list all the biros with different colours.
    What do i type in to just get biro and blue?

    Cheers!


     
  3. Select whatever from somewhere where Delivery and descriptor like "%Biro%" and descriptor like "%Blue%"
    Note this depends on Delivery being a boolean which it should be not the text "Yes"
     
  4. djphillips1408

    djphillips1408 New commenter

    What are the field names in the database, if it "pen type" and "colour" then it's pretty obvious. Are you saying that the dataset given to you contains a single field that has the words "Blue biro" in it?
     
  5. CaseBusy

    CaseBusy New commenter

    Thanks for the reply.
    the field names including some of the data are :

    Staff Company Item Unit Sales Delivery
    RT Dygitell Biro - Red (box 20) 2.4 2 Y
    RT Dygitell Biro - Blue (box 20) 2.4 4 N

    I just need a query to get a list of only Biro-Blue (box 20).

    Cheers
     
  6. CaseBusy

    CaseBusy New commenter

    thanks for the reply
    i tried the % but did not work :(
    the field names including some of the data are :

    Staff Company Item Unit Sales Delivery
    RT Dygitell Biro - Red (box 20) 2.4 2 Y
    RT Dygitell Biro - Blue (box 20) 2.4 4 N

    I just need a query to get a list of only Biro-Blue (box 20).

    Cheers
     
  7. djphillips1408

    djphillips1408 New commenter

    Like *biro* And *blue*
     
  8. CaseBusy

    CaseBusy New commenter

    thank you so much! [​IMG]
     
  9. Sorry, I forgot Microsoft and Standards can't be used in the same sentence.
     
  10. Which begs the question what is the answer in the paper ? asterisk, percentage signs ? both ?
     

Share This Page