Results 1 to 3 of 3

Thread: Date problem

  1. #1
    Join Date
    Oct 2003
    Posts
    18

    Unanswered: Date problem

    How can i perfom a calculation in a query based on the number of the month entered in to a date field by the user.

    The calculation will be the same every time but the query has to work out a value based on the amount in pounds * the number of months left in the year.

    Hope this is clear.

    Dave.

  2. #2
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511
    Use this example from a query to return the number of months left in the year, not counting the current month:

    MonthsRemaining: 12-DatePart("m",[MyDate])

    Jerry

  3. #3
    Join Date
    Oct 2003
    Posts
    18
    Spot on, thank you very much.

Posting Permissions

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