Re: How to split report on Group data.....

Hi,

Re:
Create a query. Drop the Group and ProductName. Right click in some
white space near a table and set the properties to UniqueValues = Yes.

What does uniqueValue do ?

All I want to do is add a horizontal rule accross the report page when
the GROUP changes, so that all the same grouped products are together.
There must be some simple VBA to do this in one of the headers ?

Thanks again

David


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Duplicates returned in report -- DISTINCT, DISTINCTROW
    ... SELECT DISTINCT [Recipe Ingredients].Quantity, Recipes.Instructions, ... UniqueValues and UniqueRecords are mutually exclusive -- you ... They are part of the Query ... instructions) in the form of a 5x8 index card. ...
    (microsoft.public.access.reports)
  • Re: subform issue
    ... tblOrders - in the table itself, not a combobox control in a form - then i'd ... Design view, go to the city code field, click the Lookup tab in Field ... ProductName FROM tblProducts ORDER BY ProductName; ... The subform is bound to a query based on Orders and Order ...
    (microsoft.public.access.tablesdbdesign)
  • Re: displaying additional data that correlates to my query
    ... One approach would be to take the result of your GROUP BY query and do an ... the same ProductName have the same minimum TargetDifference. ... SELECT [Flux Density Query].ProductName,MIN([Flux Density ...
    (microsoft.public.access.queries)
  • Re: Duplicates returned in report -- DISTINCT, DISTINCTROW
    ... the SQL will change from ... UniqueValues and UniqueRecords are mutually exclusive -- you can only choose one of them. ... They are part of the Query properties ... I have gotten the form to work properly as far as having all the necessary information included and fitting on the card. ...
    (microsoft.public.access.reports)
  • Re: Limit field choices based on another field
    ... I'm not making sense of the SQL statement. ... ProductName ... Allen Browne - Microsoft MVP. ... > created the stored query: ...
    (microsoft.public.access.formscoding)