Linking Second/Crosstab Query Data to a Form?

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I would like to join two sets of data onto one form. The first set of
data are in Query1 from Table1. The second set of data are in
crosstab Query2. Crosstab Query2 is a compilation of data from
Query1. I recognize that the crosstab query data cannot be directly
updated; rather, it is influenced by the data in Table1 via Query1.
Rather, I simply wish to display the data on the form along with the
other data to be updated.

Put another way: Table1 contains results from sporting events. Query1
in part compares the result of the two teams and records wins and
losses via an equation which compares the team scores. Query2 counts
the wins and losses by season. I would like the form to display data
from Query1, to be updateable, and display the data from Query2,
linked by season and updated indirectly through manipulating data from
Query1 (i.e., if I update game information, Query1 would show the
result which would then be updated in Qurey2...).

I've tried a subform within the main form, but it doesn't seem to
work. I've linked the "season" field between the two, but Access
doesn't seem to like the fact that Query2 is a crosstab query.

Any thoughts? Thanks in advance!
 
Jeff,

Dunno whether it helps but I just posted a requery problem and solution
querk that I found which may at least stop you wasting some time when it
comes to the requerying.

Regards


Rod
 
Back
Top