Want my datasheet subform to work like an excel spreadsheet.

[Joye]

I have searched and searched these posts in order to not post something already answered, but found nothing.

I have been asked so many times be people I work with if I can just have a form which looks like a spreadsheet, I have always said... NO, but thought I would give a little time to finding this out.

Breakdown - I have two tables - One is tblProjects - with project name, town, county, project type... Then there is another table called tblFundingSource. This is a one to many relationship since one project can have up many different funders.

I want to create a query or a datasheet form, based on a query which show all projects and the funders. I have created text boxes to merge data and have it show up all in one line - the problem is I cannot get rid of the additional lines as well.

Example -
Project Name - Town - Funder - $$
Smith Farm - Manchester - Johnson Foundation Grant - $230,000
Smith Farm - Manchester - Freeman Foundation Grant - $32,000
Smith Farm - Manchester - Federal Funding - $20,000

I know how to sort and group in a report, but I want to do this on the form so when people are viewing the data they do not need to see the multiple entries for one project. Any ideas????

 

[mhartman]

Hello:

You can embed the Excel application in a form.

Regards
Mark

 

[CraigDolphin]

If you only want to display the data (not allow users to do anything to it) you could also look into using a crosstab query as the recordsource for a subform control.

-Project Name (Row Header)
- Town (RowHeader)
- Funder (Column Header)
- $$ (Value)