Search results for query: *

For the grabbing most recent VALUATION part, how would you suggest that be done? A left join wouldn't come up with a result if there are no corresponding dates.

I'll do my best to answer .. hopefully this makes sense, like it does in my head!: Yes you're right it wouldn't select them, I was hoping what the query would do would be to look up each date in the query criteria (i.e. >=06/04/2013 and <=06/10/2013) against the dates in the VALUATIONS table to...

Thanks for your response Trevil620, I tried your suggestion and while it does work, it doesn't populate for values that don't exist in [ValueDate]. If it helps, here's an example of the output I was hoping for. TRANSACTIONS Table Fund TradeDate ParValue ABC 06/05/2013 50 ABC...

I have been trying without successful and wondered if the Tek-Tips forum could help me put a query together in Access. There are two tables I would like to use - TRANSACTIONS and VALUATIONS TRANSACTIONS has Fund,TradeDate,ParValue VALUATIONS has Fund, ValueDate, Price I would like to create a...

PHV - this was exactly what I needed. Thanks very much for your help and quick response!

I am wondering if somebody can help me with a VBA code that would pass a file into the clipboard. So if a file exists (e.g. C:\Temp\1.xls) I would like to pass it into the clipboard so that I could paste it into a Lotus Notes email. The following code allows me to create a Lotus Notes memo...

That works, thank you again Gruuuu you are amazing!

I have been trying to resolve this for quite some time so I thought perhaps somebody on this good board might be able to help. I am attempting to use VBA to open an IE browser, navigate to a website, and copy everything after clicking through a link. The VBA code I have does just that, and...

Gruuuu, Thank you so much for that, that is perfect ! Cheers

Hi everyone. I would like to ask if it is possible to have Excel VBA simulate a click on a piece of highlighted text. As an example, I have been able to code the macro so that it pulls the website: With IE .Visible = True .Navigate2 "http://www.citibank.com/us/home.htm" Do...