Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dustyteter

    combine worksheets in VBA

    Thank you very much Glenn, works like a charm.
  2. dustyteter

    combine worksheets in VBA

    Hey all, Below is some code that collects data from multiple workbooks and pastes the data into a master worksheet...it's not all of the code but just the part I'm interested in modifying. What need is each time I run it I want to append the master file..hence paste the new data set below the...
  3. dustyteter

    Unmatched Query not showing all fields for matching

    Table 'A' is a link back to an Oracle table. Table 'B' is an actual Access table. both tables are the same in ALL ways other than the data elements in the ACCESS table identified as NUMBERS are showing a "field size" of LONG INTEGER while the number elements in the linked table are showing...
  4. dustyteter

    Group By, MAX() Most recent date

    Thanks for you help Rudy!! That worked great! I really appreciate your help! Have a great day!
  5. dustyteter

    Group By, MAX() Most recent date

    Thank you both for your replies!! CARP, I tried your example and returned '0' rows. I'm looking into it more cause I think this may be close. R937, Your's looks like it could do something close to what I'm looking for as well but I'm using Oracle. I guess I should have mentioned that. Any...
  6. dustyteter

    Group By, MAX() Most recent date

    Here is my scenario 1 BUSINESS_ID can have multiple associated LICENSE_ID's. Both of these identifiers live in the same table as well as the CLOSURE_DT for each LICENSE_ID. DATA EXAMPLE BUS_ID LIC_CNTRL_ID LIC_CLSD_DATE 7 12165 04/05/1989 7 20494 09/30/1993 7 84565 14 40117...
  7. dustyteter

    Data followed by ellipses (02/2000...)

    That's what I would assume an ellipses means as well but it's on the first date field at the top of the report. Any other ideas?
  8. dustyteter

    Data followed by ellipses (02/2000...)

    Does anybody know off hand why some of the data fields in my Impromptu report have ellipses directly after the data? For example I have a date field in my report that is reading as 02/2000... Thanks for any input.
  9. dustyteter

    Multiple Installs of Cognos

    THANKS for the quick response flex! I guess I should have mentioned that we are indeed on a UNIX. Have you worked with this set up before? Do you know of any documentation that would discuss multiple installations on a single unix box? Besides having two environments for testing and developing...
  10. dustyteter

    Multiple Installs of Cognos

    My question is about multiple installations of COGNOS on a single box. Where wanting to have a Production and Development/testing environment and I'm trying to determine the problems of having two installations on a single box that DOES have two IP addresses. We are using PowerPlay Transformer...
  11. dustyteter

    Graph Capabilities

    Does anybody know if it's possible to assign the colors in a graph? For instance I build many reports/graphs that are broken down by region and would like to assign each region it's own particular color. Any ideas? Thanks

Part and Inventory Search

Back
Top