By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,312 Members | 1,723 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,312 IT Pros & Developers. It's quick & easy.

Populate Form with CrossTab queries and add records to them.

P: n/a
Hello all,
I want to know if this is even possible.

This is my DB structure

Table
SampleDate :

SampleID SampleDate Comment
1 1/1/2005 X
2 1/1/2006 Y
Table DateParameters :

SampleID ParameterID Value
1 AG 0.1
1 AL 0.2
1 MG 0.3
2 AL 0.6
2 MG 0.5
Now, I want to create a form where I need it to look like this for
example when the SampleID = 1

SampleDate AG AL MG
1/1/2005 0.1 0.2 0.3

1). I guess this is possible using a crosstab query. Where do I find
examples of how to dynamically attach a crosstab query to a form's
input ?

2). Can the users update these values and then how will they be stored
back in the database ?

3). Can they add new records (new values for AG,AL and MG on new dates)
? how will they be updated as two tables have to be updated ?

Any articles which illustrate this would be highly appreciated too.
Please remember that I need this for an interactive form.
Thanks,
Anirudh Garg

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The answer to 2 and 3 is No. A crosstab query is not updateable.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"anirudh" <an*********@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Hello all,
I want to know if this is even possible.

This is my DB structure

Table
SampleDate :

SampleID SampleDate Comment
1 1/1/2005 X
2 1/1/2006 Y
Table DateParameters :

SampleID ParameterID Value
1 AG 0.1
1 AL 0.2
1 MG 0.3
2 AL 0.6
2 MG 0.5
Now, I want to create a form where I need it to look like this for
example when the SampleID = 1

SampleDate AG AL MG
1/1/2005 0.1 0.2 0.3

1). I guess this is possible using a crosstab query. Where do I find
examples of how to dynamically attach a crosstab query to a form's
input ?

2). Can the users update these values and then how will they be stored
back in the database ?

3). Can they add new records (new values for AG,AL and MG on new dates)
? how will they be updated as two tables have to be updated ?

Any articles which illustrate this would be highly appreciated too.
Please remember that I need this for an interactive form.
Thanks,
Anirudh Garg

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.