Tough one! Replicate Access query, with join, in Excel VBA???

  • Thread starter Thread starter Kobayashi
  • Start date Start date
K

Kobayashi

Does anybody have any idea whatsoever how I can perform the following
query in Excel VBA?

UPDATE FIOP, [1 - Make FTR] SET FIOP.WOR_Fail_Reason = "Firm Short"
WHERE ((([FIOP].[WOR_Fail_Reason])="OFTR") AND
(([FIOP].[FirmCode])="SBIL" Or ([FIOP].[FirmCode])="SBUKE") AND (([1 -
Make FTR].[Cusip]) Is Null));

The [1 - Make FTR] is a dataset first created from a Select query:

SELECT *
FROM FIOP
WHERE ((([FIOP].[FTDFTR])="FTR"));

Ever hopeful,

Adrian
 
Can anybody let me know if there is a posting etiquette that I am not
adhering too?
I haven't received any responses to my last two posts, which
considering the very timely responses I've had previously makes me
wonder I am not adhering to posting rules? Perhaps it's just that
nobody can help with the posts I've made but, knowing the amount of
MVP's who frequent this site I can't believe this is the case?

Therefore, please let me know where I'm going wrong?

Best Regards,

Adrian
 
Back
Top