2 Replies - 192 Views - Last Post: 30 April 2013 - 08:33 AM Rate Topic: -----

#1 Bountyhunter1234  Icon User is offline

  • D.I.C Head

Reputation: 19
  • View blog
  • Posts: 72
  • Joined: 12-May 09

printing a report for past "x" months

Posted 26 April 2013 - 09:37 PM

Hi im in the process of creating a DB for my final and i may be a little over zealous. The class is just the basics of access so we didn't go into VBA code and very little SQL. I personally know a little vb so figuring out VBA shouldn't be to hard im just looking for a little push in the right direction on how i can code a report to print up the last 6 months and save to a file. I have a macro pointing towards a query that asks for two perams i would like to know if there is a way to hard code those variables to be the day the button is clicked from 6 months before.

This post has been edited by Bountyhunter1234: 26 April 2013 - 09:38 PM


Is This A Good Question/Topic? 0
  • +

Replies To: printing a report for past "x" months

#2 Luckless  Icon User is offline

  • </luck>
  • member icon

Reputation: 292
  • View blog
  • Posts: 1,146
  • Joined: 31-August 09

Re: printing a report for past "x" months

Posted 29 April 2013 - 09:12 AM

DateAdd("m", -6, Date)


will get the date from six months ago =)
Was This Post Helpful? 1
  • +
  • -

#3 Bountyhunter1234  Icon User is offline

  • D.I.C Head

Reputation: 19
  • View blog
  • Posts: 72
  • Joined: 12-May 09

Re: printing a report for past "x" months

Posted 30 April 2013 - 08:33 AM

thanks a lot luckless
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1