Search results

  1. A

    I bet this is actually quite a simple query....

    For you guys: http://www.unitedwaysb.org/Ice%20Cream.jpg But heres another challenge to test your brains... Here are my IFF statements IIf([age]<16,"under 16", IIf([age]>=16 and [age]<=20,"16-20", IIf([age]>=21 and [age]<=25,"21-25", IIf([age]>=26 and [age]<=30,"26-30"...
  2. A

    I bet this is actually quite a simple query....

    You guys are absolute superstars!
  3. A

    I bet this is actually quite a simple query....

    OK, that looks like it could be right.... but what do I do with this line?? Iif([age]<16,"<16",Iif([age]<20,"16-20",Iif([age]<25,"20-25", ....)))) This is pretty embarassing - I'm very new at Access!!!!!!!!
  4. A

    I bet this is actually quite a simple query....

    Hey all I wonder if someone can help me out on what I think should be a simple query (although i can't seem to do it!) I've got a table that looks like this... Table_IceCreamLovers Person_ID Age Gender PostCode Favourite_flavour Now All I need to do is find out how many people there are...
Back
Top Bottom