make a spreadsheet with report

[shank]

I have the below query I'd like to get into a report. Is it possible to get
a report to build a spreadsheet or that format look? What I want is the
Company names across the top and the AcctName going down the left side. What
I'm hoping to do is generate an 'x' in the associated boxes where there's a
match. Is this possible?

SELECT SalesCompany.Company, AssignedCompany.AcctName
FROM SalesCompany INNER JOIN AssignedCompany ON SalesCompany.ID =
AssignedCompany.CompanyID;

thanks!

 

[Jeff Boyce]

Not only can you (depends on which version of Access) "export" a report to
Excel, you can decide to export the data only to an Excel spreadsheet,
without ever generating a report.

Create the query that returns the data you want. Save it. Highlight it,
and use File|Export and select an Excel format.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[shank]

I'm not trying to export to Excel.
I'm trying to make a report that looks like Excel.
I need a repeat region that goes horizontally for the headings (companies).

 

[Jeff Boyce]

I tend to use a more brute force approach.

If I need something to look like Excel, rather than trying to recreate
functionality in Access, I export the data to Excel.

Regards (and good luck!)

Jeff Boyce
Microsoft Office/Access MVP