Search results

  1. L

    Percentages help :)

    hey there i need help :) ok, so i have to work out week by week percentage uses i have a query that already finds the bookings in the week already, that works fine, but then i need to find the % use for that week, which is the count of the number of bookings in the week / 21 ive tried doing...
  2. L

    Query percentages

    im doing the same project :D and thought the percentages were week by week..?
  3. L

    iif statement

    thanks man you've helped a lot, just having one problem :eek: see attached screen dump :) problem is that i dont want the text to be saved i only want the price to be saved, but just the opposite is happening at the moment lol i used the wizard :) so dont have any code anyone know of the...
  4. L

    iif statement

    i have a table and im working on two fields one is the session part of day where you can only enter "Morning", "Afternoon" or "Evening" Then i have a cost field Morning and Afternoon both cost £12 Evening costs £15 when someone types in the part of day i want the price to come up automatically...
  5. L

    Postcode validation

    sorted using an input mask makes it so much easier i am pretending they only come in one form, but i can live with that
  6. L

    Postcode validation

    hello all this thing is really bugging me im trying to come up with a post code validation and i have tried dozens, which should have worked really, but just havent so wondering if you guys knew any examples of postcodes would be BN3 8JH BN41 8JH theyre the only two types that are bound to be...
  7. L

    hellllllllllllpp please :D

    a what what? talk to me as if i was a 5 year old lol, i might as well be for all i know about databases thanks
  8. L

    hellllllllllllpp please :D

    well where to begin i'll start by saying i dont know much about queries, i know the basic stuff, but thats all ok, well i have 3 tables, one a booking table, one a customer table and one a table with costs there are 5 seperate prices and 2 months data and i need to total up for each month it...
Back
Top Bottom