Search results

  1. L

    notification

    I have a form with a registration date. What I would like to do, but do not know if it is possible or do not know how to do it, is that it should look at the registration date, and if it is 30 days or 60 days for that matter, a notification should pop up for that particular record telling the...
  2. L

    calculating number of years in job

    I have a table with the LName, FName, Rank, Date_Employed. I need to create a query that will calculate the number of years that the person has been working up to the current day. Is this possible, and if so, how can I do this? Thank you for your help!
  3. L

    converting to grams in a table from a form

    Hi, I have this form which contains a table with fields that they can enter in ounces, another field for pounds, and another for kilograms. I also have another field which is calles convt_grams. What I would like to do is allow the user to enter in ounces, lbs, or Kg, and the database to...
  4. L

    Count

    I got this report which is group by Police Officer, with an arrest date, incident, LastName, First Name, and Violation. The way it works now is that the officer may display a total count of 9 because there were nine Violations - which may include two violations for the same person. The problem...
  5. L

    print date range in report

    I have this report which runs based on a query. Under the criteria for the DATE field, I have put a >=[SDate] and <=[EDate]. My report works okay, but what I would like to do is print that date range. I cannot figure it out. Can anyone suggest anything? Thank you!
Back
Top Bottom