Search results

  1. C

    Loop a Copy of a row.

    hmm, I am really confused. So let's say we have the following example. Table 1 ContactID Area Team Date Status 1020 London 932 1/1/2013 1 * 1020 Leicester 877 1/2/2013 1 *...
  2. C

    Loop a Copy of a row.

    Ok i understand. The other question is how will i be able to count the total days of a contact in a specific area. I mean i dont kknow the way for dealing with the gaps between.
  3. C

    Loop a Copy of a row.

    Sure, but when I want to print a report showing the status(area & team number) of all 250 members at a specific date (say 14/11/2011) the members that do not have a record for that specific date won't appear at all when the filter is applied. That's why I am confused.
  4. C

    Loop a Copy of a row.

    You got a point on this because i didn't explain all the details. So let me explain further my situation. This access database will be used in a boy scout organisation that needs a daily printed report containing the total number of contacts (members), the area each contact is located at this...
  5. C

    Loop a Copy of a row.

    Hello and thanks for the prompt reply. These records would be needed because it is Essential to know in which area every contact is located every day. In order to do so i would need to add a new record Every day for each of 250 contacts. So to avoid this it is easier to have an automated...
  6. C

    Loop a Copy of a row.

    Hello all!! I am new in access and vba coding so I need some help to evaluate the following issue: I currently have a SECONDARY table with the following fields. 1. ID 2. ContactID 3. Date 4. Status 5. Area 6. Team The MAIN table contains the following: 1. ID 2. ContactID 3. Contact Name 4...
Back
Top Bottom