ACCESS FEED: Re: [MS_AccessPros] how to build report

Jumat, 16 Januari 2015

Re: [MS_AccessPros] how to build report

It scares me to do this cuz I'm afraid you'll find dozens of rookie mistakes that I've made throughout the database but I will upload the entire database.

There are three reports that will need to have the columns. As I said I didn't use subreports for any of them. But that will probably be the easiest wrong for me to right.

Thanks!

Jessica

On Friday, January 16, 2015 12:38 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Jessica-

What is the structure of your tables and the report query?

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jan 16, 2015, at 7:16 PM, Jessica Hoback hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

How do I get each column to show data from a different record - all from the month of January?

I have a report built using a query that joins all of the necessary tables. It works fine to get the data from my first record but I'm stuck on getting the next record to fill in the second column. I exported what I have to a PDF that I will upload - "sample track report". (I didn't use a subreport but I think that will be easy enough to change).

While we're at it, at the top of the form there are also boxes to show a running record count for Year to Date and Career to Date. Can you also help me with a formula for those?

Thanks!
Jessica

On Friday, January 16, 2015 11:07 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Jessica-

I would build an outer report for year, month, and user, then a subreport in 3 columns. You might be able to use a Wizard to get a jumpstart on the subreport, then tweak the settings to get three columns.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jan 16, 2015, at 5:52 PM, hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Happy Friday all!

I am trying to build a report that displays multiple records, each in it's own column on the report. I have already designed the report based off another version already being used. I will want to be able to query by month and user to run the report.

The report would look somewhat like this

Month: January Year: 2015 User: Jessica H

Record1 Record2 Record3

Date

Time

Etc.

Each record will have all of the same fields which will make up my row headers.

Is this possible? I'm a novice Access user so if it is possilbe I appreciate simplified or "dumbed down" responses. Fingers crossed that I can do this in a query rather than code.

Thanks!

Jessica