Simple Query not working

  • Thread starter Thread starter raja
  • Start date Start date
R

raja

Hello,

trying to do a simple query but it is not working. I have
a table Last_Date with 1 value in it. I am trying to use
the value [MaxofCXEFT] from Table Last_Date in a query on
another table, but I keep getting a prompt box is there an
eaiser way.
eg.
SELECT PRODDTA_F0015.CXCRCD, PRODDTA_F0015.CXEFT,
PRODDTA_F0015.CXCRR, PRODDTA_F0015.CXAN8,
PRODDTA_F0015.CXCDEC, PRODDTA_F0015.CXCRDC,
PRODDTA_F0015.CXCRRD
FROM PRODDTA_F0015
WHERE (((PRODDTA_F0015.CXCRCD)="BRL") AND
((PRODDTA_F0015.CXEFT)>[Last_Date]![MaxOfCXEFT]) AND
((PRODDTA_F0015.CXCRDC)="USD"));
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try this:

SELECT CXCRCD, CXEFT, CXCRR, CXAN8, CXCDEC, CXCRDC, CXCRRD
FROM PRODDTA_F0015
WHERE CXCRCD="BRL" AND
CXEFT > DMax("CXEFT", "Last_Date" AND
CXCRDC="USD"

If you don't want to use the DMax() function you can do this:

SELECT CXCRCD, CXEFT, CXCRR, CXAN8, CXCDEC, CXCRDC, CXCRRD
FROM PRODDTA_F0015
WHERE CXCRCD="BRL" AND
CXEFT > (SELECT Max(CXEFT) FROM Last_Date) AND
CXCRDC="USD"

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQTUC7YechKqOuFEgEQJG7wCfQkm+NYQTfvbofpdTHXtPhOvtK/UAn14T
u9ubav3mOAViZXIk2M/JrqUL
=RuEw
-----END PGP SIGNATURE-----
 
Back
Top