Re: Formatting/Coding a Report...

You could build a query which gives you all of the data fields that you want
from the various tables. Then you could export the query a an Excel
Spread*** if you like, or you could set up a report with that same
information.

If the "look" you're going for is a spread***, I would shoot for the
export to excel option rather than trying to make it look that way using the
report tool.

Linda

"PerplexedPeon" <PerplexedPeon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5F588C3E-06F9-49D7-B4FB-E4DF22521F61@xxxxxxxxxxxxxxxx
> OK, here's the situation which has left me absolutely perplexed...
>
> I have inherited a semi-complete database project from a former employee
> which tracks clients. We store the client list in a single table along
> with
> whether they are new or existing clients. Other tables are used for the
> representatives' names, location(office) information, program codes etc.
>
> What I am required to do here is create a report that for all intents and
> purposes resembles a spread***. The format would have the rep's names
> across the top and program codes on the left. Under each rep. I need two
> 'columns'; one for the total clients a rep has brought in over a given
> date
> range and the second for a YTD running total. Also, there would be a
> final
> totals column on the right side of the report for individual programs and
> a
> grand total at the bottom of this column.
>
> Being new to VBA I am not sure if this can even be accomplished since none
> of the wizards got close to what's needed. Any guidance would be
> extremely
> appreciated.
>
>
>
>


.