Search results for query: *

Ah fixed the issue, reversed the fields and have now WHERE VTD_trans_vnd not in (select VTD_vnd_nbr from VW_DCBVTD). Gave me expected results. Thanks so much for your help this issue was really holding me up

Thanks for the suggestions, I did not quite get the results I wanted though. I am starting with 8008 0 8009 0 8010 0 8011 0 8012 0 8013 0 8014 0 8015 8008 8016 8008 I got 8009 0 8010 0 8011 0 8012 0 8013 0...

Hi, I am using Crystal 9 linked to an Oracle Database. I have two fields set up like below. Vendor number is a unique identifier. I would like to direct my query not to select any vendor number if it appears anywhere in the transvendor field. With the example below, I would like my query to show...

Hi sorry I am using Crystal v 9. When I added the formula as indictated above I get an error message saying "this function cannot be used because it must be evaluated later

Hi, I am new to Crystal and have been looking around today but haven't been able to find an answer to this. I am want to use a maximum value as a selection criteria. Ie output has multiple records based of accounts for all purchases, IE Acct Number Purchase Date Purchase Id Purchase Item...

Thanks so much for the reply. This works well

Hi, I would like to use a formula in excel for an automatic date function and am not having much luck getting it to work. Specifically I want a past date. The below is what I would use if it was in a cell. =TODAY()-7 Am I beating my head against a wall for nothing, is it simply not possible...

The original macro resides in Excel however as part of a bigger macro in access I want to run the excel macro from access which the code above does as a module, however in the automated Access Macro which I want to start with running the excel Macro I cannot find a way to run a module

Hi, I am trying to run this in Access. When I try to use runmacro it does not give me the option of running this because it is a module. I would love it just to be a macro so I can use runmacro.

Hi, I am trying to run an excel macro from within an automated access macro. Through some VB code I got from another forum I was able to write what I thought was a macro in Access that does the job, however it has saved as a module. I have not yet taken Visual Basic (start on April 7) so I don't...

Thanks, that does help in a sense because it confirms that what I want it to do is not possible so I can stop looking.

Hi, I use Tasks in Outlook 2000 to assign tasks to my reports. This works very well except when I assign recurring tasks. When they mark a one time task as complete, it will update the task both in their Outlook and in mine, however when they mark a recurring task as complete it updates in their...

I have created two sumfiles and am now trying to create a report containing information combining the two. They are keyed and there are matched and unmatched records. I am currently getting ouput that is giving me only the unmatched records. I would like to get both matched and unmatched. Please...