Yesterday I was having issues with Null fields in my Crosstab query when
trying to calculate wins and losses for a team.
That problem is fixed. That problem is fixed and teams with no wins or
loses get a zero in their field. My teams sort correctly based on a
calculated win percentage. My reports sort correctly by grade and sport. I
thought I was on my way to victory but. Now I want to have a 2nd query pull
information from the crosstab query for just one specific sport, such as
Basketball. I set up a form, (I call it a Chooser form) with an unbound
combo box that looks at the t_sport and selects a sport and stores the value
for later use. Column 1 is bound, which is where the SpoID number is.
In all the other queries I have set up like this everything runs perfect.
With this 2nd query, as soon as I add the crosstab query to the design
window I get the following message.
The Microsoft Office Access database engine does not recognize
'[Forms]![f.RecordRankingChooser]![cboSport]'
If I remove the crosstab query from my query design window it runs fine
again. So now I have a great crosstab query that calculates wins, losses
etc, but I have no way to sort the information by sport.
I do not understand why pulling information from a crosstab query will all
of sudden not allow my query to see a combo box value.
Do you need the SQL
Thank you for your wisdom. Yesterday I researched the Nz function so I
now have added that to my toolbox.
Bill
MN
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar