Access Query to ODBC

  • Thread starter Thread starter florycane
  • Start date Start date
F

florycane

Hi everybody the following query is running fine from Access but when I am
putting the same query it in a access form to query the database and export the
results to an Excel file, it does not return any results.....

SELECT BPS_MRS.MR_NUMBER, BPS_MRS.MR_DESC,
BPS_BID_VENDOR_HEADERS.BIDV_VEND_SEQNO, BPS_BID_VENDOR_HEADERS.BIDV_VCON_SEQNO,
BPS_BID_VENDOR_HEADERS.BIDV_PO_SEQNO, BPS_BID_VENDOR_HEADERS.BIDV_RP_FLAG,
BPS_PO_HEADERS_V.PO_NUMBER, BPS_PO_HEADERS_V.VENDOR_ID,
BPS_PO_HEADERS_V.VENDOR_NAME, BPS_PO_HEADERS_V.REV_NO,
BPS_PO_HEADERS_V.REV_DATE, BPS_PO_HEADERS_V.DESCRIPTION,
BPS_PO_HEADERS_V.BUDGET_VALUE, BPS_PO_HEADERS_V.ESTIMATED_VALUE FROM
((BPS_MR_REVISIONS RIGHT JOIN BPS_MRS ON BPS_MR_REVISIONS.MRV_MR_SEQNO =
BPS_MRS.MR_SEQNO) LEFT JOIN (BPS_BID_VENDOR_HEADERS RIGHT JOIN BPS_BID_PACKAGES
ON BPS_BID_VENDOR_HEADERS.BIDV_BIDP_SEQNO = BPS_BID_PACKAGES.BIDP_SEQNO) ON
BPS_MR_REVISIONS.MRV_BIDP_SEQNO = BPS_BID_PACKAGES.BIDP_SEQNO) LEFT JOIN
BPS_PO_HEADERS_V ON BPS_BID_VENDOR_HEADERS.BIDV_PO_SEQNO =
BPS_PO_HEADERS_V.PO_ID WHERE (((BPS_MRS.MR_NUMBER) Like '*-MRA-*' And
(BPS_MRS.MR_NUMBER) Not Like '24956-MTL*'))


Any help will be highly appreciated.......

thanks
 
Just a shot in the dark, but see whether replacing the asterisks with
percent signs makes a difference:


BPS_PO_HEADERS_V.PO_ID WHERE (((BPS_MRS.MR_NUMBER) Like '%-MRA-%' And
(BPS_MRS.MR_NUMBER) Not Like '24956-MTL%'))
 
Back
Top