Display Distinct Row as Summary - Objectif Lune Tech Support Self Help

IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

You are not logged in. [Log In] Objectif Lune » Forums » PlanetPress Suite 7 » PlanetPress Design » Display Distinct Row as Summary

Topic Options

#42588 - 03/07/13 07:03 AM Display Distinct Row as Summary
Oliver Unregistered	Hi, I am using an MSAccess DB as a sample data in my Design and I have a query from MSAccess that joins multiple tables. Is there a way for me to Display Distinct Records on my first page(summary page)? My plan is to create a statement that in the first page it will display a summary and the succeeding pages will be the detailed page. Or is there a way to have multiple tables as my Sample Data?
Top

#42594 - 03/07/13 09:59 AM Re: Display Distinct Row as Summary [Re: ]
Raphael Lalonde Lefebvre OL Expert Registered: 10/14/05 Posts: 4956 Loc: Objectif Lune Montreal	Oliver, These options do not exist through the standard interface of the Database emulation, so you will have to use an Advanced Query with SQL. When using the Database emulation, you can click on "Edit SQL", which allows you to use SQL to make more advanced queries. There, you can join tables, do select distinct, etc... and the resulting recordset will be used as your data. Hope that helps! Regards, Raphaël Lalonde Lefebvre
Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: Alex Banahene, cosimo, Jean-Cédric, OL Newsgroup QA, OL Newsgroup Support, OL Newsgroup Training, Philippe F., Raphael Lalonde Lefebvre