Search results

  1. C

    Solved Sum([Unbound Field]) in Continuous Form Using VBA Loop

    Asking for help please. Using an unbound text box in the footer of a subform I am trying to calculate a sum of values from a recordset in a continous form using a loop. Additionally, the field for which I am trying to sum is also an unbound field that holds an expression. dB file attached...
  2. C

    Send Attachment Fields to Email as Attachments

    Requesting assistant with getting files (could be zero, 1 or more) from attachment field in MS Access to attach to an email in MS Outlook. I have tried using code examples from the following two posts below which seem to have a combination of what I'm trying to achieve: 1. Sending...
  3. C

    Formatting time conversion

    Looking for help on a formatting issue regarding elapsed time calculated using DateDiff(). I understand that you can specify the output value for DateDiff(). In my case I have chosen "n" for minutes. Each result in my query shows the correct calculation in terms of minutes. [PunchIn] =...
  4. C

    Calculating elapsed time within a time period

    Greeting everyone. This is my first post. I have a working dB which can calculate a shift duration and sum total all shifts worked within a period for the purpose of producing a labor report for payroll. I have successfully used the DateDiff function and converted the minutes to HH:MM on my...
  5. C

    Hello from Seattle

    Greetings everyone! I have always been interested in learning about database design and development but I never imagined that I would enjoy it as much as I do. I am mostly self taught but have taken one college level course for database design. I continue to build projects to solve work...
Top Bottom