User Profile

Collapse

Profile Sidebar

Collapse
quantumkev
quantumkev
Last Activity: Jan 24 '08, 04:26 PM
Joined: Dec 13 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • quantumkev
    replied to Is ADO really dying?
    in SQL Server
    Yes - that's what I have been seeing too. Thanks for the reply - I guess I can keep coding away!...
    See more | Go to post

      Leave a comment:

    • quantumkev
      started a topic Is ADO really dying?
      in SQL Server

      Is ADO really dying?

      Hello All -

      I keep seeing posts stating something like "ADO is dead", or that MS is moving to another technology for data access. I make use of ADO in almost all of my applications, and the last time I looked at the "Data Access Roadmap"(???) on MSDN, it stated that MS was still going to keep enhancing ADO.

      So what is the real truth? And what is now the recommended technology for accessing SQL Server...
      See more | Go to post
      • quantumkev
        started a topic Network application usage mystery
        in Windows

        Network application usage mystery

        Hello -

        We have an Access database on a network drive, and I am currently trying to figure out who may have it open. All of our PC's are Windows based, and we use Novell as our NOS. Is there any tool or utility for finding out who has an application open on a shared drive?

        Any advice or assistance is greatly appreciated.


        Q-kev
        See more | Go to post
        • quantumkev
          replied to Combining Aggregate functions in Access (SQL)
          in Access
          NeoPa,

          Thank you so much for the detailed explanation - I greatly appreciate it.This technique will open up a lot of new possibilities for me.

          I hope you and yours have a very Happy Holiday Season.
          See more | Go to post

            Leave a comment:

          • quantumkev
            replied to Combining Aggregate functions in Access (SQL)
            in Access
            Wow - that's awesome! Thank you.

            I understand the general concept, but would you mind explaining the whole "fiddling with the vendor_id" part? That seems to be the part I am getting hung up on and don't quite understand. This line in particular :
            Code:
            Val(Mid(Max(Format([SumInv],'000000000') &
                   [vendor_id]),10)) AS MaxVendor,
       Max([SumInv]) AS MaxInv
            Once again - thanks...
            See more | Go to post

              Leave a comment:

            • quantumkev
              replied to Combining Aggregate functions in Access (SQL)
              in Access
              Thank you both (Rabbit and NeoPa) for the replies. However, I don't think I stated the question clearly enough, as I had already done what you suggested, but didn't get the result I am looking for.

              I am trying to retrieve the total inventory, product id, and vendor id for the single product with the Maximum total inventory.

              For example : for product 1, there are 7 total for vendor number 3, and 5 total for vendor number...
              See more | Go to post

                Leave a comment:

              • quantumkev
                started a topic Combining Aggregate functions in Access (SQL)
                in Access

                Combining Aggregate functions in Access (SQL)

                Hello,


                I have a question that has been dogging me for awhile now, and I would like some fresh insight :

                Given a table of products (product_id), each with a specific inventory (inv_count), and each provided by a certain vendor (vendor_id) in a 'Products' table as below
                [HTML]product_id inv_count vendor_id
                1 2 3
                1 ...
                See more | Go to post
                No activity results to display
                Show More
                Working...