View Poll Results: Please help

1. You may not vote on this poll
  • Expression Builder

    0 0%
  • Text Items

    1 100.00%
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002

    Unanswered: Inserting Date Field at the bottom of a Access 97 report

    Hi All,

    I am a new MS Access 97 programmer. The customer I work for would like the following date format to be displayed at the bottom of their report.


    The Week of March 2002

    The calculation of the date is the current date minus one month. In other words, if the current date is April 2002 the date should be displayed as the previous example. My question is, what is the best and easy way to have this data displayed? Do I use the expression builder or place hard code to a text item? Any input would be greatly appreicated. Thanks in advance for all your help.

  2. #2
    Join Date
    Sep 2001
    Chicago, Illinois, USA
    ="The Week Of " & Format$(DateAdd('m',-1,Date()),"mmmm") & " of " & Year(DateAdd('m',-1,Date()))

    Do you want the number of the week?

Posting Permissions

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