Odd Report Question 2

[sucoyant]

Good day!

I have a simple report that groups data by BatchID from the Batch table which consists of:

Batch Table:
custAccountNum
BatchID
BatchDate

An example can be seen here:

My report looks like this: (Minus the red lines, which will be explained later)

Now, as you can see by these red lines that the same account number shows up multiple times, just on different dates and BatchID's.

How would I go about making the report look like this:

It eliminates the repeating groups and places them on the bottom in a "date, date, date" fashion instead of it repeating the same account number 3 times. One for each date.

Is this possible?

________________________________________

Buddha. Dharma. Sangha.

 

[dhookom]

There is a generic concatenate function at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

This will create your multiple date values. You can then sort/group your report by the
=Len([YourOutputfield])


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[CosmoKramer]

Check out this FAQ for an alternative method: faq703-3587

Hoc nomen meum verum non est.