Forum Discussion

gilbert7's avatar
gilbert7
Copper Contributor
May 04, 2020

Unable to run the queries in Ms access

Hi guys,   I am Gilbert Fernandes. I am facing difficulties in running the queries in access database.   There are three tables: OrderTemp , OPS$OMAUTH_OMA_WAREHOUSE_ORDER and Tbl_SERVICE_ORDER ...
access
Access Web Database
George Hepworth's avatar
George Hepworth
Iron Contributor
May 04, 2020

gilbert7 Try removing the HAVING clause. 

 

You have this:

HAVING (((OrderTemp.ST_ID)="SKY"));

Is ST_ID really a text string?  

Resources