Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GreekTony

    How do I display previous month in Access Report

    Cheers Remou, this work perfectly. Much appreciated :)
  2. GreekTony

    How do I display previous month in Access Report

    I have modified your formula Remou to this =DateAdd("m",-1,(Now())) This then displays: 03/03/2006 14:40:00, which is halfway there as the month shown is March which is correct. How do i now get it to just display the month only? I have played around with the formuala adding in "mmmm" in...
  3. GreekTony

    How do I display previous month in Access Report

    Hi Remou your suggestion didnt work :( I keep getting a enter parameter message box pop up everytime i try and run the report. Thanks for the help tho
  4. GreekTony

    How do I display previous month in Access Report

    Hello, Basically i have a report which I compile using last months data, and i would like this to be displayed on the report. For example at the moment it is april, so the report should display march. I have been playing around with the formula below to no avail :( =Format(Now(),"mmmm yyyy")...

Part and Inventory Search

Back
Top