Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Globalized
    Posts
    14

    Cool Unanswered: SOLVED: [Newbie] The Now() function

    The following query was created in Access

    SELECT [Clients].[agency_name], [Projects].[invoiced], [Projects].[paid], [Projects].[fee], [Projects].[invoice_date], DateDiff("y",[Now()],[Projects.invoice_date]) AS DaysElapsed
    FROM Clients INNER JOIN Projects ON [Clients].[client_id]=[Projects].[client_id]
    WHERE ((([Projects].[paid])=No));

    Works fine in Access as I test it. It does however ask for me to enter the value for the Now() function. Ok. And it returns the records as expected.

    However, I need to create a list of these records inside a form control, say a combobox. When I bind the combobox to this query, it still pops up the dialog box for Now(). I thought it was supposed to get this info automatically from my system date

    What am I getting wrong?

    Thanks.
    Last edited by LostFrog; 01-09-04 at 22:03.

  2. #2
    Join Date
    Jan 2004
    Location
    Globalized
    Posts
    14

    Talking Solved it myself

    Ah, ok, putting [] around the Now() function makes it work like a parameter. No brackets makes it work as it should. OK, I learned something new today

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •