Search results for query: *

We have a number of documents such as Bob Service Report MTD.xls or Susan Service Report MTD.xls or Steve Service Report MTD.xls, that feed into one document. The original Vlookup looks like this =VLOOKUP($A7,'[Bob Service Report MTD.xls]Fee Reversals'!$A:$AA,6,FALSE) Occasionally $A7...

I am trying to get it so that in field D53 would be the persons name, such as Susan or Rick. Then try to get the Vlookup to show something like this =VLOOKUP($A7,'[D53 Service Report MTD.xls]Fee Reversals'!$A:$AA,6,FALSE) That way I only have to change one field instead of 40.

I am just came into a situation where the current report has multiple Vlookup formula's that look like this =VLOOKUP($A7,'[Bob Service Report MTD.xls]Fee Reversals'!$A:$AA,6,FALSE) I am trying to get to the point where I can have the name be a field location, like D53. This way I can change...

This is probably a stupid question, but everytime I open a crystal report with VB it opens up another window with crystal. I was wondering if it was possible to open up multiple crystal reports in one window using VB.

Hello I am using Access 97 and am trying to make a macro that will import a tab separated text document when I click a button. The problem I'm having is that the name of the text document changes ona daily basis. For example today it was called "Recon 07-21-04" tomorrow it will be called...

I have one running total field where the type of summary is set to maximum and I need to subtract it from another running total field that is set exactly the same way. i would appreciate any help anyone can give me.

Worked great. Thanks for making me look good for my boss.

I have in a table a field that has the number of seconds since January 1st,1970 at midnight and was wondering if there was any way to build an expression to convert it to a regular date time.