Generate automatic report number in Access 2007
I’m creating a db to track reports for my organization in Access 2007.  We have a unique report numbering system.  For example, a report number would be GR-50-12-002, where GR and 50 are constants, 12 is the year, and 002 is the second report issued that year.  I want to create a form to add [...]

Answer Question   |  May 22, 2012  5:42 PM
Microsoft Access 2007, Microsoft Access reports

Creating a new report with a macro in Access 2010
I currently have a macro that pulls in a very large text file, delimits it and then opens up the table. Now I want my macro to basically press the Report button to create a report. The OpenReport macro will open up a report that is already defined but doesn’t seem to “create” a report [...]

Answer Question   |  April 25, 2012  8:10 PM
Microsoft Access 2010, Microsoft Access reports

Pull up a list of the last time the person took each course set-up in the system
I have a training database and I can easily pull up a report of all dates a person took courses but I would like to just get a report of the last time a person took each course. I do not want multiple listing of a course.

Answer Question   |  February 28, 2012  2:32 AM
Microsoft Access 2007, Microsoft Access reports