Hi Gang.



I'm producing a report where I list a number of properties and they're

related details, including the state that the property is located.   Rather

than produce a group summary after every state (sums, averages), the client

wishes to have a separate 'state totals' section underneath the property

listings.  Is this possible without using a sub-report?



I.e.. - Is it possible to move the details from each 'state footer' to the

'report footer'  or should I just stick to using a sub-report? I don't mind

creating the sub-reports, only that the final report will then need to

include about 20 sub reports!!



TIA



/Andrew

Andrew,

In the report footer section you can use the Dcount function. Create a

text box and in its ControlSource property use

=DCount("[NameifYourStateField]","[NameofTable]","[NameifYourStateField]

='WA'").This will give you a total for that particular State. The only

drawback is that you will either have to make a textbox for every state

or know ahead of time what states are represented in your data and make

boxes for them.



Richard Lobel

Accessible Data

richard@a... <mailto:richard@a...> 

Cell:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx



***Original Message***

I'm producing a report where I list a number of properties and they're

related details, including the state that the property is located.

Rather

than produce a group summary after every state (sums, averages), the

client wishes to have a separate 'state totals' section underneath the

property listings.  Is this possible without using a sub-report?

Doh - forgot about Dcount.  Thanks Richard - will give that a try.



Cheers,



Andrew



-----Original Message-----

From: Richard Lobel [mailto:richard@a...]

Sent: Tuesday, 22 January 2002 9:50 PM

To: Access

Subject: [access] RE: Report Groupings





Andrew,

In the report footer section you can use the Dcount function. Create a

text box and in its ControlSource property use

=DCount("[NameifYourStateField]","[NameofTable]","[NameifYourStateField]

='WA'").This will give you a total for that particular State. The only

drawback is that you will either have to make a textbox for every state

or know ahead of time what states are represented in your data and make

boxes for them.



Richard Lobel

Accessible Data

richard@a... <mailto:richard@a...> 

Cell:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx



***Original Message***

I'm producing a report where I list a number of properties and they're

related details, including the state that the property is located.

Rather

than produce a group summary after every state (sums, averages), the

client wishes to have a separate 'state totals' section underneath the

property listings.  Is this possible without using a sub-report?