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 Chriss Miller 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. Nick366

    Double Pipe in a string problem

    Looking again, I see I mis-read that. Sorry, ignore my last post. ;)
  2. Nick366

    Double Pipe in a string problem

    It looks like you might be repeating info. If I am reading this correctly, you want something like this as a result: insert into TABLE1 (A, B, C) values (1, 2, 3), (4, 5, 6), (7, 8, 9); The way it is set up, it is putting it like: insert into TABLE1 (A, B, C) values (1, 2...
  3. Nick366

    PL/SQL - Create table??

    Is it possible to create a table within a PL/SQL block? Basically I am checking user_tables to see if a table exists, and if it doesn't then I am creating it. declare v_count number; begin select count(*) into v_count from user_tables where table_name = 'TEMP_2YEAR_DRIVER'; if v_count =...
  4. Nick366

    Does anyone know of a good alternative to TOAD?

    I like Benthic's Golden program. Not as cluttered as TOAD...
  5. Nick366

    HOW TO GET DATA IN ORACLE TABLE FROM ACCESS TABLE

    There are a few ways to do it. If it is not many rows, you could create an insert script. If you have a program like Golden, there should be Data Import/Export tool. I usually just use the Import function in Benthic's Golden.
  6. Nick366

    SQL Query - Selecting From Nested Query

    Turk, The snippit I posted was just the FROM section of the query, not the whole thing. The whole thing is much longer. If that section looks correct, then I might need to focus looking else where in the query. I did paste my query into the window you suggested, but it is rejecting it saying...
  7. Nick366

    SQL Query - Selecting From Nested Query

    Thanks for your input. There is nothing wrong with my SQL. I can run that statement in a different program, such as Toad or Golden, and it will return exactly what I want. The question was and still remains, how do I get this statement that works in other programs to work in Crystal Reports...
  8. Nick366

    SQL Query - Selecting From Nested Query

    I am using CR 8. I am trying to select information from multiple tables and am getting snagged by an invalid character. My best guess is that I am getting hung up on the FROM protion of my SQL Query. I am trying to select information from a nested query. My from statment looks similar to...
  9. Nick366

    Requery subform by list selection

    I think it is choking on me not moving out of that field. Since it is still editing the record, it has not been updated yet. I did find a work around. I created another subform of a datasheet of the OfferIDs. Not as clean, but functional. I still would like help on this question though...
  10. Nick366

    Requery subform by list selection

    My goal: Have a listbox full of OfferIDs. I want to display the detailed information for a perticular OfferID when it has been selected in the listbox. Here is what I am doing, that is not working: Created table to hold the selected OfferID. Main form is based off of this table. Put a...
  11. Nick366

    Mouse Stop Scrolling through records

    This should help. http://www.microsoft-accesssolutions.co.uk/disable_mousewheel.htm
  12. Nick366

    Horizontal scrollbar for list box?

    Same question, but with only one column. I have one column that can span say 3", but I only want the list box to span 1.5". Is there a way to scroll across to the right to view the missing text?
  13. Nick366

    Push SubReports and Fields down when...

    Underlay is working, but now it is forcing the other two sections to the following page. It looks like this: ---------------- | SubReport 2 | | | | | | | - - - - - - - - -...
  14. Nick366

    Push SubReports and Fields down when...

    Ok, something is not working. It will not allow me to put a SubReport within a SubReport. So I created an outside Report to incorporate the two SubReports. Then when I attached that outside report to the main report, the SubReports within do not show up.
  15. Nick366

    Push SubReports and Fields down when...

    Thanks!!!
  16. Nick366

    Minimum date from multiple records

    Got it!!! Thanks guys!
  17. Nick366

    Minimum date from multiple records

    My selection formula is filtering for records with null values in the Expired_Date column. I think that is causing it to continue to display the 1/26/04. Is there anyway to have this pull the minimum from all records, grouped by BookName?
  18. Nick366

    Minimum date from multiple records

    The database table I am looking at has legacy data. I am looking to get the minimum start date, but the rest of the data from the current record. Here is an example: Table: BOOKS Fields: Name Description Release_Date Expired_Date ABCook Cooking 12/30/2003...
  19. Nick366

    Push SubReports and Fields down when...

    Ok, I figured out a little of it, but still need help in this issue. I found out that I am able to add other detail sections, and that works great of a portion of my report. The other thing I need to do is... ______________ _______________ | SubReport 1 | | SubReport 2 | | | |...
  20. Nick366

    Push SubReports and Fields down when...

    ...there is a growing SubReport above. I am using Crystal Reports 8. I have a growing SubReport above other SubReports. The problem is, the top SubReport is growing over the lower SubReports. How do I get it to push the other Fields/SubReports down on the sheet? Thanks in advance for any...

Part and Inventory Search

Back
Top