Search results

  1. R

    Number of Days that fall in a Period

    Hi I have a database which is unfortunately in Access 2000 due to that being the only version available within the company. I need to query the number of days that fall in each period (13 periods in the year). I have attached a sample with 3 records in the table. Course 1 = 5 days in...
  2. R

    Purpose built function needed to count days in a period

    Hi I have a large piece of data which I "was" minipulating in Excel, using complex formulas and some vba, but as I know will be looking at various reports, I have imported them to Acess as tables... And was trying to query the table na dpull the number of days. Unfortunately I am struggling...
  3. R

    form for multiple tables, multi yes/no fields...

    I have 3 tables as below... Fields Level 1 - Level 10 are Yes/No fields. I need to set it up so that in a form when I had a new role, there are the 10 Yes/No fields available to assign the checks to. Each Role will have 21 Profiles (which don't change) and each of the Profiles will have...
Back
Top Bottom