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!

Recent content by sqlwp

  1. sqlwp

    Subtotal

    That would certainly work but I would have to do it for over 10 columns that I'm trying to subtotal. I was looking for a way to do it more dynamically through a formula. It looks like that might not be possible.
  2. sqlwp

    Subtotal

    Because there are other subtotals that need all values for column A.
  3. sqlwp

    Subtotal

    The sumproduct formula doesn't work if autofilter is used on any of the fields in the worksheet, that's why I need to use subtotal.
  4. sqlwp

    Subtotal

    I don't know how to tell the subtotal command to look at every cell in column A for an "R" and sum the associated value in column B. If I use a condition with the subtotal it only looks at one cell: =IF(A12="R",(SUBTOTAL(9,B12:B45623)),0) How do I give it a range condition?
  5. sqlwp

    Subtotal

    I could split out the value in column B based on the value in column A and subtotal those columns individually, but this spreadsheet is huge and contains many columns that I have to total based on this condition so I would rather not have to do that. I have to use the subtotal function because...
  6. sqlwp

    Subtotal

    I need to do a conditional subtotal on a field. If any cell in column A is the value "R" then sum the associated value in column B. How can I accomplish this with a subtotal? I need to use subtotal because autofiltering can be used on many different columns.
  7. sqlwp

    Constraint still allows scanning on field

    I have multiple tables that I union together into a view. Each table has a check constraint on it for the same field but different value for each table. When I do a select on the view including the constraint field in the where clause the execution plan still shows all tables in the view being...
  8. sqlwp

    Query runs slower on newer server

    I am in the process of moving my sql database to a newer server(Windows 2003, SQL 2000) from (NT/SQL 7.0). The server has 2 more processor and more memory. My update queries are taking twice as long to run on the new server. It doesn't look like it's using the processors, it seems like it is...
  9. sqlwp

    Disable keyboard actions

    It doesn't seem to stop the MS Windows key.
  10. sqlwp

    Communication link failure

    Its SQL 7.0 database. I've tried it with Crystal 9 and Seagate Info 7.5 and it fails on both. The driver is SQL 2000.85.1022.00. (2/20/2003). Other network connectivity is fine, no other application fails. PC's that have the problem and that don't both have the same version of Crystal, same...
  11. sqlwp

    Communication link failure

    When accessing a database with Crystal in design mode when I run the report the first time it runs fine, and if I keep running it within a few minutes it's fine, but if I let the report sit there for more than a few minutes when I try to run it again I receive a "communication link failure" and...
  12. sqlwp

    Disable keyboard actions

    Do you know of an example of one somewhere?
  13. sqlwp

    Disable keyboard actions

    Can you do it in VB?
  14. sqlwp

    Disable keyboard actions

    Is there any way to prevent the action of the Windows key and the print screen key?
  15. sqlwp

    Table Comparison

    If I run sp_table_validation on each table and compare the checksum values work?
See more

Part and Inventory Search

Back
Top