Search results

  1. J

    How to select beyond the date range?

    hi, how do I select my data where the date is beyond the date range specified? For instance, I wan to select all the rows except the rows that are between 3/22/2005 to 10/17/2005. Is it possible to select the query? I tried the condition 'where date < #3/22/2005# and date > #10/17/2005#', but it...
  2. J

    Sum up the values calculated.

    hi I am making a late report of each employee's data and I calculated for each individual day by having late for how long, but I would like to make another column which displays the total amount of time late. This is currently what I have now: My SQl looks like this: SELECT username...
  3. J

    How do I arrange my data column?

    hi, I have a table that looks like this: And I wan to query my data that looks like this so that I can display the start time and the end time of each distinct date and in every user: How can I do lidat? I appreciate anyone who is able to help me, and this is an access database
Back
Top Bottom