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: Trying to get fancy
      ... I have always added a Boolean field to such tables and used a fake listbox ... go through the selection process again. ... They check what they want to see and run the report from the form. ... No code to write and you just add a Field = True to teh query. ...
      (microsoft.public.access.formscoding)
    • Re: Update Queries and Record Locks
      ... The value of the boolean field is completely dependent on whether or not DateCompleted has a value. ... Field: CompletedYN: DateCompleted Is Not Null ... My problem is I have multiple users in a form that runs off tblOrders that are in records as this query is happening. ...
      (microsoft.public.access.modulesdaovba)
    • 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)