Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

wallay

IS-IT--Management
Dec 4, 2002
3
GB
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"
 
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.
 
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.
 
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")) AS TG1, Max(IIf([Target_Group]="TG2","Yes","No")) AS TG2, Max(IIf([Target_Group]="TG3","Yes","No")) AS TG3, Max(IIf([Target_Group]="TG4","Yes","No")) 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
 
Wocca

Thanks for the code.

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

Have a good one.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top