Rabu, 20 Mei 2015

Re: [MS_AccessPros] Query Trouble

 

John,
 
I uploaded a PDF sample of what the report looks like.  I don't always explain things very well.
 
Jessica 



On Wednesday, May 20, 2015 9:57 AM, "hobackjessica@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
 Good morning group!
 
I have a query built that appears fine in datasheet view.  In this view it shows each record one time.  However, when I open the query in a report I have problems. 
 
My report is set up with a subreport to show my results in columns.  Each page shows a specific user and a specific month's records.  For example, page 1 should show UserA and all records from May - right now I have two.  However, since there are two records the report shows both records on page 1 and there's a page 2, also with both records.  If I have three May records for UserA there will be three pages, all showing all three records. 
 
How do I tell my query or report not to create a page for every record?
 
Jessica


__._,_.___

Posted by: Jessica Hoback <hobackjessica@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (10)

.

__,_._,___

Tidak ada komentar:

Posting Komentar