Search results

  1. M

    complete beginner in writing codes

    Hi, I have just started "coding" in VBA 2 days ago... I am trying to do a function as follows: Ratio = value/Davg(value) value being a field in a table we can call table. I got to this stage: Function Ratio(value) Ratio = End Function I have managed Ratio = 1/value, or Ratio = value +1 and...
  2. M

    Yes/No format and check boxes

    Hi, I am doing a query in which I input a formula IIf(Value>0,Yes,No) and would like to see the results appear as check boxes ticked or unticked instead of lists of Yes and No. Apparently there is a way to change the format in the properties but I can't see how! Any ideas??? Cheers :rolleyes:
  3. M

    I think I need to do an update query

    Hi, First time on this forum, I really hope I'll get a reply! Here is the situation: I have a table with an ID, and a velocity value. I want to calculate for each ID the velocity value/the average of all the velocity values. This is very easy to do on excel but not on Acces! The main problem...
Back
Top Bottom