Jumat, 16 Januari 2015

Re: [MS_AccessPros] how to build report

 

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 
(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.

Etc.

Etc.

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

 

__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar