Access 2000, Is it possible to pass a report result to a form.

[wallay]

We have a report that gives a concatenated result of the many side relationship of a table. Is it possible for this field to then be passed to a temp table.
eg. a Project table could have many Target groups. The report shows a 1 line entry of the Project and all the Target Groups. "Test Project" has "TG 1", "TG2", "TG3"

 

[pdldavis]

Hi, if your concatenations are done in the reports underlying query, you can select 'query' from the tool bar then 'make table query' when in design view.

If your concatenations are done in a report, a roundabout way of doing it is to export the report to excel and then import the spreadsheet back in as a table.

Hope that helps.

 

[wallay]

pdldavis
Thanks for your comments.
Unfortunatley the database is on the web so rules out the excel or word export/import routine.
Because the concatanation is done within the report, I cannot call the query.
Do you know of a way to concatenate with a query ?

I appreciate your help.

 

[Wocca]

If there are a fixed number of target groups (i.e. Test Project has TG 1, 2, 4 of potential TG 1-4, Test Project 2 has TG 1, 3 & etc) you could use a query with grouping by projects & formulas for each TG like


SELECT Project_Target_Group_Listing.Project, Max(IIf([Target_Group]="TG1","Yes","No&quot) AS TG1, Max(IIf([Target_Group]="TG2","Yes","No&quot) AS TG2, Max(IIf([Target_Group]="TG3","Yes","No&quot) AS TG3, Max(IIf([Target_Group]="TG4","Yes","No&quot) AS TG4
FROM Project_Target_Group_Listing
GROUP BY Project_Target_Group_Listing.Project;

Or a variation thereof.

Hope I understood what you were after & this helps.

Regards
Warwick

 

[wallay]

Wocca

Thanks for the code.

I will try it out over the weekend and get back to you,

Have a good one.