Recent content by dunkyn

Question on this one. I am doing exactly this from a query with start and end date parameters, but when I run the report it prompts me twice for the same date parameters. Why? How do I get rid of the second set?

I have created a word macro and saved it in a template on a shared network drive, in order to share the program with other users. The template contains a custom toolbar to invoke the macro. When we link to this template via Tools Add-ins & Templates, the custom toolbar does not always stick...

thx

I need to group on a field, then sort on a detail field, then group on additional fields. Problem is this...it defaults to grouping, then sorting. So, my output appears as ABC Bond 9-22-2005 GHI Bond 3-01-2001 XYZ Bond 12-31-2003 Grouped on the asset name (which is required, but I want to...

Thank you lbass. That is helpful too. Unfortunately, when I click on the "Mark this post as a helpful/expert post!" nothing happens. I think there may be a hiccup. It worked for me before, but now nothing....

I am unable to star this for your help? Is there a problem with the site?

Perfect! Thx!

Any advice on how to avoid division by zero with a select case statement? Here is what I have: whileprintingrecords; If {sp_Classified_Position_Report;1.VALVAL_CMB_AMT}>0 then SELECT {sp_Classified_Position_Report;1.ASSET_CLASS_MNEM} Case "FIXED INC&quot...

perfect! thank you!!

Naith, Appreciate your help. I have been successful in extracting the value, when there is a value in the explanation text. However, my dilemma is what to do if no "$" appears, and excluding these. I am getting error messages because of this issue. Any thoughts out there on a...

Naith, No luck. I get text, not a number ? How does the replace function extract just the value following the $ sign?

INTEL CORP COM 474 SHARES TO CHARITABLE FDN A/C #99999999 TAXPAYER ID: 04-9999999 MADE DECEMBER 3,2002 AT VALUE $9,731.22 or TRANSFERRED TO PORTFOLIO 11111111 SSN# 111-11-1111 COMPLETION OF $1,500.00 GIFT TO xyz charity.... I just want to extract the $9,731.22 or the $1,500.00 and make it a...

I need to extract a $ value from a string. Sometimes the string does not have a $ value in it. How do I exclude these strings? I am getting an error message "Start position is less than 1 or not an integer. Formula for @TestforValue (look for $ to find value): "$" in...

Thank you.

Just what I needed. Thank you! What does Cstr stand for? I like to understand what I'm doing, other than reformatting a number?