Hi All - this has been wrongfully p 1

[georgesOne]

Hi All - this has been wrongfully posted as Sharepoint thread (820-1693394)... I start again here - my apologies:

I generated a crosstab query which shows people working on specific project duties.
With a subsequent select query I select the people active in the duty I am interested in, but this query contains all (duty) columns generated by the crosstab query.
I would like to delete those (unknown) duty columns, which contain only null values...

How could I do that... imagine you get following crosstab table:

Person[Tab]ProjectA[Tab]ProjectB[Tab]ProjectC[Tab]ProjectE
AA[Tab][Tab][Tab]50[Tab][Tab][Tab]50
BB[Tab][Tab][Tab]100
CC[Tab][Tab][Tab][Tab][Tab][Tab][Tab][Tab][Tab][Tab][Tab]100
DD[Tab][Tab][Tab]25[Tab][Tab][Tab][Tab][Tab][Tab][Tab][Tab][Tab][tab][Tab][Tab]75

Now I want all people participating in ProjectA listed together with the projects they additional work in, like

Person[tab]ProjectA[tab]ProjectB[tab]ProjectE
AA[Tab][Tab][Tab]50[Tab][Tab][Tab]50
BB[Tab][Tab][Tab]100
DD[Tab][Tab][Tab]25[Tab][Tab][Tab][Tab][Tab][Tab]75

Note that PersonCC and ProjectC should not appear.

Thanks for any insight.
best, georges

 

[dhookom]

It would help if you provided the SQL view of the crosstab. One solution would be to create a query that selects only those persons working in ProjectA. Then join this to the Person in the crosstab query design. You might also consider a subquery in criteria of the crosstab.

Duane
Hook'D on Access
MS Access MVP

 

[georgesOne]

Thanks a lot... exactly what I did.
It (almost always) happens that I come to a solution after posting here!
Thanks anyway, georges