counting days in a query

From: Ike (rxv_at_hotmail.com)
Date: 12/26/03

  • Next message: Bjorn Abelli: "Re: counting days in a query" 
    Date: Fri, 26 Dec 2003 19:47:00 GMT

    How can I make a query such that in the "WHERE" part of my clause, I want to
    put something to the effect that, say, X days have elapsed since a given
    date.
     For example, suppose in my table, I have a boolean field and a date field.
    I want to create a query asking for those rows where X days have elapsed
    from the date field in a row and the boolean, say, is false.

    Do I need to create a third field, called, say "X" for how many days have
    elapsed between the date field and today, and update every row in the table
    every day?

    Thanks, Ike

  • Next message: Bjorn Abelli: "Re: counting days in a query"

    Relevant Pages

    • RE: Display fields Limited on Values
      ... "Duane Hookom" wrote: ... boolean field names. ... I created the database yesterday. ... I also made another query that displays the ...
      (microsoft.public.access.queries)
    • RE: Display fields Limited on Values
      ... person/requirement should create a single record in a related table. ... boolean field names. ... I also made another query that displays the ... I have created a rather lengthy query to display everyone who has ...
      (microsoft.public.access.queries)
    • Re: convert "yes" to 2 then add all fields
      ... Are Yes and No text fields, or is that a Boolean field that's formatted as ... you can create a query that has a computed field in it: ... Pick an empty column in the grid, put your cursor in the Field row of ... that column and hit Shift-F2 to bring up the Zoom box. ...
      (microsoft.public.access.gettingstarted)
    • Re: Excel Database Query String Too Long
      ... either add a boolean field to the DB named: ... or create a table of Ärchived Projects and then create an query like ... > I am trying to update a workbook to remove many> of the values from an Access database query. ... > I am working on getting them to "archive" older projects, so we don't> have to exclude so many. ...
      (microsoft.public.excel)
    • Re: Excel Database Query String Too Long
      ... either add a boolean field to the DB named: ... > I am trying to update a workbook to remove many> of the values from an Access database query. ... > I am working on getting them to "archive" older projects, so we don't> have to exclude so many. ...
      (microsoft.public.excel)