Rabu, 20 Mei 2015

[MS_AccessPros] Query Trouble

 

 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: hobackjessica@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar