Re: A GROUP BY QUESTION ....

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi John Nurick

Can i reply to your Mail?

The details will be more accurate.

just let me know how do you want it.

Thanks for your help

Best regards


>-----Original Message-----
>Hi Jose,
>
>Please tell us more about the tables, the fields they
contain, and the
>relationships between.
>
>
>On Thu, 7 Apr 2005 06:00:03 -0700, "Jose"
><anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
>>hello everyone:
>>
>>I have a table structure like the one bellow:
>>
>>HEADER1 Enterprise
>> Header2 Client #1
>> Detail Details of client #1
>> Detail
>> Detail
>> Trailer2 Footer of client #1
>> Header2 Client #2
>> Detail Details of client #2
>> Detail
>> Trailer2 Footer of client #2
>>Trailer1 Footer of Enterprise
>>
>>The records must appear in this order
>>
>>i have five forms where i populate the fields of those 5
tables
>>
>>to make a relation between tables Header2, Detail and
>>Trailer2 i create the field Client
>>
>>I really wanna know how should i do in order to have my
>>records sorted in the way i show above .
>>
>>This is supposed to become a TXT file to send by e-mail
>>
>>i have tried the UNION ALL issue but i think a GROUP by
>>statement.... but i am not so shure about it....
>>
>>
>>I would appreciate very much all the help that everyone can
>> give to me....
>>
>>
>>Thanks in advance
>>
>>Best regards to all of you
>
>--
>John Nurick [Microsoft Access MVP]
>
>Please respond in the newgroup and not by email.
>.
>
.

Relevant Pages