Search results

  1. A

    query based form ....... check box to select items

    query based form ....... i have a multiple item form based on a query. in this form, some tasks are listed. i need to be able to select several tasks and to add them into a table. these tasks are picked up, at the user decision, using a check box, located on the same row with each individual...
  2. A

    previous record in query

    hi, from the beginning you must know that i am a beginner with access. i come with a very old issue, i saw a lot of threads, but nothing fits my case to solve the below problem: i built the following query: task id - perform at date 1002 - 06/23/2011 1002 - 06/11/2011 1002 - 06/14/2011 1004 -...
  3. A

    history, traceability of a event

    guys, i am trying to build a table to store all the history events for a task: like, when was carried out (date/time format), who carried it out, using how many resources, and so on. all these info are different types of formats: from date/time, number and text. i want to create a ContentTable...
  4. A

    dmax returning max value under 10 hours

    :( I am trying to use the Dmax function in a query to return the max value for a time field. The expression used is: E1: dmax(“totaltime”,”query1”) Totaltime is defined as a Dsum expression in the same query. Totaltime output are values are in the short time format (hh:mm). The result of...
  5. A

    Running sum for time in Queries

    Friends, I need to calculate the running sum of the time difference. I know how to do it for numbers, but for time fields i have no clue, sample table: ID Start time End time 1 10:15 11:05 2 11:45 12:05 3 12:45 13:00 4 2:50 3:00 5 23:05 2:05 Sample query: ID Start time End...
Back
Top Bottom