Connecting Tech Pros Worldwide Forums | Help | Site Map

Dynamically add columns to a form using CrossTab queries

anirudh
Guest
 
Posts: n/a
#1: Nov 13 '05
Hello,
I have a knotty problem. I have a table :

say table A:
ParameterID InBatch
Algae 1
Ammonia 0
Potassium 1
Magnesium 1
Sodium 0

I have an access form, in which I want to show the fields ParameterID
which have an Inbatch value of 1 as columns, i.e
the form should dynamically make Algae, Potassium and Magnesium as
columns if the table looks like what it is above.
Is it possible to do that ?

Thanks,
Anirudh Garg


David Schofield
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Dynamically add columns to a form using CrossTab queries


On 10 Dec 2004 15:06:39 -0800, "anirudh" <anirudhgarg@gmail.com>
wrote:
[color=blue]
>Hello,
>I have a knotty problem. I have a table :
>
>say table A:
>ParameterID InBatch
>Algae 1
>Ammonia 0
>Potassium 1
>Magnesium 1
>Sodium 0
>
>I have an access form, in which I want to show the fields ParameterID
>which have an Inbatch value of 1 as columns, i.e
>the form should dynamically make Algae, Potassium and Magnesium as
>columns if the table looks like what it is above.
>Is it possible to do that ?
>
>Thanks,
>Anirudh Garg[/color]

Hi
(forms, reports)
See How to create a dynamic crosstab report in Access 2002 at
http://support.microsoft.com/default...;en-us;Q328320
-David




Closed Thread


Similar Microsoft Access / VBA bytes