Microsoft Jet engine does not recognize "

[Guest]

I am creating a report break down by area code. I use cross tab in query and
form to input the area code. Each time, the form pompt to enter the area
code. After I enter the area code, it show up the error message as "Microsoft
jet engine does not recognize " as valide frield name and expression. " The
cross tab query is as following:

PARAMETERS [Forms]![Area Code Dialog]![AREACODE] Text ( 255 );
TRANSFORM Sum(comp1.SUBS) AS SumOfSUBS
SELECT comp1.WEEK, Sum(comp1.SUBS) AS TOT
FROM comp1
WHERE (((comp1.AREA_CODE) Is Not Null And (comp1.AREA_CODE)=[Forms]![Area
Code Dialog]![AREACODE]))
GROUP BY comp1.WEEK
PIVOT comp1.COMP_CODE;

Is there anyone who can give some suggestion? Thanks.

Jy

 

[Duane Hookom]

Does the error message mention a field name that is not recognized? Are
there any weird values in the COMP_CODE field?

 

[Guest]

Error message doesn't mention a field name that is not recognized. But I
check each field. On comp1.AREA_CODE field, there are some records on
comp1.AREA_CODE value are ?? that are weird. But those records are required
to keep to get correct number to caculate the total. What should I do if this
is the problem? Thanks.

Happy Holiday.

Jy

Does the error message mention a field name that is not recognized? Are
there any weird values in the COMP_CODE field?

--
Duane Hookom
MS Access MVP
--

I am creating a report break down by area code. I use cross tab in query
and
form to input the area code. Each time, the form pompt to enter the area
code. After I enter the area code, it show up the error message as
"Microsoft
jet engine does not recognize " as valide frield name and expression. "
The
cross tab query is as following:

PARAMETERS [Forms]![Area Code Dialog]![AREACODE] Text ( 255 );
TRANSFORM Sum(comp1.SUBS) AS SumOfSUBS
SELECT comp1.WEEK, Sum(comp1.SUBS) AS TOT
FROM comp1
WHERE (((comp1.AREA_CODE) Is Not Null And (comp1.AREA_CODE)=[Forms]![Area
Code Dialog]![AREACODE]))
GROUP BY comp1.WEEK
PIVOT comp1.COMP_CODE;

Is there anyone who can give some suggestion? Thanks.

Jy

 

[Duane Hookom]

Don't allow users to enter crappy data. If the actual value in the field is
"??" then replace the ?? with something or create your column heading like:

PARAMETERS [Forms]![Area Code Dialog]![AREACODE] Text ( 255 );
TRANSFORM Sum(comp1.SUBS) AS SumOfSUBS
SELECT comp1.WEEK, Sum(comp1.SUBS) AS TOT
FROM comp1
WHERE (((comp1.AREA_CODE) Is Not Null And
(comp1.AREA_CODE)=[Forms]![Area Code Dialog]![AREACODE]))
GROUP BY comp1.WEEK
PIVOT IIf(COMP_CODE = "??", "UNK",COMP_CODE );


--
Duane Hookom
MS Access MVP
--

Error message doesn't mention a field name that is not recognized. But I
check each field. On comp1.AREA_CODE field, there are some records on
comp1.AREA_CODE value are ?? that are weird. But those records are
required
to keep to get correct number to caculate the total. What should I do if
this
is the problem? Thanks.

Happy Holiday.

Jy

Does the error message mention a field name that is not recognized? Are
there any weird values in the COMP_CODE field?

--
Duane Hookom
MS Access MVP
--

I am creating a report break down by area code. I use cross tab in query
and
form to input the area code. Each time, the form pompt to enter the
area
code. After I enter the area code, it show up the error message as
"Microsoft
jet engine does not recognize " as valide frield name and expression. "
The
cross tab query is as following:

PARAMETERS [Forms]![Area Code Dialog]![AREACODE] Text ( 255 );
TRANSFORM Sum(comp1.SUBS) AS SumOfSUBS
SELECT comp1.WEEK, Sum(comp1.SUBS) AS TOT
FROM comp1
WHERE (((comp1.AREA_CODE) Is Not Null And
(comp1.AREA_CODE)=[Forms]![Area
Code Dialog]![AREACODE]))
GROUP BY comp1.WEEK
PIVOT comp1.COMP_CODE;

Is there anyone who can give some suggestion? Thanks.

Jy