Joined: 15 Dec 2015
Location: United States
Online Status: Offline
Posts: 2
Topic: Latest Date Posted: 15 Dec 2015 at 8:53am
Very new to writing. My database will pull multiple rows when I ask for persons with charges in the LastFullMonth. I just want to know IF they had a charge. I don't need to know how many or the dates. But I get multiple rows when I use that as a selection. What can I write to only get one row per person if they have any charge for that timeframe?
Thank you in advance
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 23 Dec 2015 at 8:51am
Try this:
- Group by person - either name or concatenate name and person id (if there can be more than one person with the same name).
- Put the data in the person group header.
- Suppress the details section and the person group footer section.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
