Recent content by MSLamoureux

  1. M

    Average of a calculated fields in Queries

    Ooops! :D Thank you soooo much!! That works just fine!!
  2. M

    Average of a calculated fields in Queries

    Hi again, Ok I've been trying this: My query DelaiAttente In one field I have : TempsAttente: Round(DiffDate("j";[DateEngagement];[DateRendezVous])/7*5) That point works fine. Now I've tried to put and unbound text field in a form and in the source control...
  3. M

    Average of a calculated fields in Queries

    I'd tried so many things. First I managed to create a field inside the form where the different date are filled but I can see by reading here that we shouldn't put a calculated field into a form. But anyway it wasn't working. I had first created the field TempsAttente and wrote this formula in...
  4. M

    Average of a calculated fields in Queries

    @Beetle That's exactly the problem I think. I'd actually been able to get the calculated field "Delai" with this formula Délais:Round(DiffDate("j";[DateEngagement];[DateRendezVous])/7*5) Witch provide me the delai by day between the two dates and now I need to know the average delai so the...
  5. M

    Average of a calculated fields in Queries

    Hi, I've been trying to insert a field that would calculate the average of another calculated field in a queries. So I have a field name "ReceptionDate" and "AppointmentDate" I would like to have a queries that would in one field named "Delai" calculate de delai between these two dates...
  6. M

    Hello All!

    Ok. So here I am, I'm an office agent who works for a non profite organisation and all day long I "play" and "argue" :p with a database on Access. I often have to create reports, stats, modify forms to better suits our needs etc.. So I often need help because I never really had a training on...
Top Bottom