What is the SQL of your query? If you are using this as the record source for a report, are you setting the Column Headings property or how are you ensuring all fields get generated?
Duane
--- In MS_Access_Professionals@yahoogroups.com, "agent1of6" <Bill.Singer@...> wrote:
>
> Bill,
> Well that worked. WOW. I would not have figured that our. I set the data type of [Forms]![f_RecordRankingChooser]![cboSport] as an Integer. I also tried a text just for fun and as expected it did not work. The 2nd query which is the report query pulls from the crosstab query. Both queries run correctly and sort per the combo box on my form.
>
> But now the report does not run because it 2nd report query shows no available fields.
>
> When I run the report it says "The Microsoft Access database engine does not recogonize " as a valid field name of expression"
>
> I tried to design a new report off of the 2nd query and in the report wizard the query shows no fields available.
>
> Another error message that is similar but I am not sure what next.
>
> ....except for tonight, sleep is next.
>
> Thanks for your help.
> Bill
> MN
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Bill-
> >
> > Open your Crosstab query in Design view. Open the Parameters dialog. Define
> > [Forms]![f_RecordRankingChooser]![cboSport] and set its data type from the
> > drop-down list. Save your query.
> >
> > John Viescas, author
Tidak ada komentar:
Posting Komentar