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!

  • Congratulations strongm 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: *

  • Users: bruns
  • Order by date
  1. bruns

    Query: MIN function working...MAX returns NULLs

    Hey James - I was able to integrate your solution into my Crystal Query and it's working nicely. Whatever they're paying you...it's not enough!!! Thanks again, --Brad [2thumbsup]
  2. bruns

    Query: MIN function working...MAX returns NULLs

    Thanks for the quick reply James. Your first "rewrite" does get me the most recent statement when I run from Query Analyzer...very cool. I'll work on trying to integrate that into the bigger query (which is why I need the join). Although I may have a problem translating that into a...
  3. bruns

    Query: MIN function working...MAX returns NULLs

    Hi all - My SQL expertise is amateur at best, so hope this is documented correctly. QUERY: select financial_statement.acct_nbr, financial_statement.stmt_dt from account, financial_statement where account.acct_nbr *= financial_statement.acct_nbr and account.acct_nbr = '123456' and (stmt_dt =...
  4. bruns

    PC Constantly Reboots right before NT Splash Screen (Vid Card problem?

    To KNPORTER : I went into PNP/PCI Config in the BIOS setup and indeed found that "Assign IRQ for USB" was ENABLED as well as "Assign IRQ for VGA". I changed the IRQ for USB to DISABLED, saved change and restarted. Still busts at the splash screen. Was that where to resolve...
  5. bruns

    PC Constantly Reboots right before NT Splash Screen (Vid Card problem?

    To WOLLUF - Great point about NT and USB not meshing...didn't see that until after the fact :) Anyway, as far as by "installing" the USB PCI card, i physically placed it into a PCI slot and then tried to boot up which is where my original Vid Card started to fail so I hadn't even...
  6. bruns

    PC Constantly Reboots right before NT Splash Screen (Vid Card problem?

    Running Windows 4.0 SP6a, 733 MHZ, 384 MB RAM. Was running fine for the last year. Installed a USB 2.0 PCI card yesterday and tried to boot up and I heard one long beep followed by 3 short beeps. Audio Error code table indicates "Video Failure". The monitor light reamains orange...

Part and Inventory Search

Back
Top