A
Andy
Hi;
My query is returning Chinese and Greek characters. The error message is
"Data type mismatch in criteria expression".
The query is based on 2 other querries, (the first pulls from the Main
table, (Customer), the second from a Sub table, (ProductsBought).
I've created 3 expressions, (nothing in the Criteria row).
Exp1: IIf([qryProdBuyTbl]![ProdBuyCatagoryName]="Clothing" And
[qryProdBuyTbl]![ProdBuySubCategoryName]="Shirts",[qryProdBuyTbl]![ProdUnits
Bought]*[qryProdBuyTbl]![ProdBuyUnitPrice]," ")
Exp2: IIf([qryProdBuyTbl]![ProdBuyCatagoryName]="Clothing" And
[qryProdBuyTbl]![ProdBuySubCategoryName]="Pants",[qryProdBuyTbl]![ProdUnitsB
ought]*[qryProdBuyTbl]![ProdBuyUnitPrice]," ")
Exp3: IIf([qryProdBuyTbl]![ProdBuyCatagoryName]="Clothing" And
[qryProdBuyTbl]![ProdBuySubCategoryName]="Shoes",[qryProdBuyTbl]![ProdUnitsB
ought]*[qryProdBuyTbl]![ProdBuyUnitPrice]," ")
If only 1 item is selected the answer is displayed correctly. If 2 or more
items are selected the mismatch occurs.
Have discovered the following things:
Changing the arguments to ,"Yes","No") returns a correct answer.
Occasionally deleting 2 of the expressions, (doesn't matter which 2), will
display a square and a lower case r.
When copied and pasted into MSWord the font for the square is Chinese, (at
72 points it is an artistic Chinese character) and the R is Greek.
When I highlight either character and try to change to a different font; if
the font has the ability to display Chinese or Greek the font name changes;
if not, the font name remains the same.
When the expressions are placed in the qryProdBuyTbl, (pulls only from the
Sub table), they work perfectly.
Anyone have any suggestions?
Thank you.
Andy
My query is returning Chinese and Greek characters. The error message is
"Data type mismatch in criteria expression".
The query is based on 2 other querries, (the first pulls from the Main
table, (Customer), the second from a Sub table, (ProductsBought).
I've created 3 expressions, (nothing in the Criteria row).
Exp1: IIf([qryProdBuyTbl]![ProdBuyCatagoryName]="Clothing" And
[qryProdBuyTbl]![ProdBuySubCategoryName]="Shirts",[qryProdBuyTbl]![ProdUnits
Bought]*[qryProdBuyTbl]![ProdBuyUnitPrice]," ")
Exp2: IIf([qryProdBuyTbl]![ProdBuyCatagoryName]="Clothing" And
[qryProdBuyTbl]![ProdBuySubCategoryName]="Pants",[qryProdBuyTbl]![ProdUnitsB
ought]*[qryProdBuyTbl]![ProdBuyUnitPrice]," ")
Exp3: IIf([qryProdBuyTbl]![ProdBuyCatagoryName]="Clothing" And
[qryProdBuyTbl]![ProdBuySubCategoryName]="Shoes",[qryProdBuyTbl]![ProdUnitsB
ought]*[qryProdBuyTbl]![ProdBuyUnitPrice]," ")
If only 1 item is selected the answer is displayed correctly. If 2 or more
items are selected the mismatch occurs.
Have discovered the following things:
Changing the arguments to ,"Yes","No") returns a correct answer.
Occasionally deleting 2 of the expressions, (doesn't matter which 2), will
display a square and a lower case r.
When copied and pasted into MSWord the font for the square is Chinese, (at
72 points it is an artistic Chinese character) and the R is Greek.
When I highlight either character and try to change to a different font; if
the font has the ability to display Chinese or Greek the font name changes;
if not, the font name remains the same.
When the expressions are placed in the qryProdBuyTbl, (pulls only from the
Sub table), they work perfectly.
Anyone have any suggestions?
Thank you.
Andy