Formatting/Coding a Report...

[Guest]

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 spreadsheet. 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.

 

[Linda Burnside]

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
Spreadsheet if you like, or you could set up a report with that same
information.

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

Linda