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. Hollymc

    Trying to find if a purchaser that made a return ever came back

    Thanks a bunch. That made perfect sense. What I may do is a simple join to just find the ones that did return something and then run what you gave me and see who repurchased. The reason for this is sending Christmas cards to clients. And I don't want to send a Card to a jackass that bought...
  2. Hollymc

    Trying to find if a purchaser that made a return ever came back

    I am trying to find out how many of my online purchasers ever bought anything and returned it and if they returned again and purchased something. So A buys B and returns B and then comes back and buys C and keeps it. I only want those that come back and buy junk from me. Heres what I have so...
  3. Hollymc

    Real easy question regardin what I can access

    I inherited my company and all that came with it including the database. I would love to be able to find what I have available to me. I have two tables: Contacts, Transactions within transactions I have Category1, category2, category3, etc.. Category1 is items, things like books, cake...
  4. Hollymc

    Aggregate help

    Never mentioned what I would like to have happen... :) I would like for the second query, the individual one to report purchase amount return amount purchase amount return amount purchase amount return amount instead of purchase null null null null...
  5. Hollymc

    Aggregate help

    I am running a query that finds all the clients that buy from me and return stuff within a certain range. In a range of 5 days it will give me 200 people. Now I want to see of them, who are the repeat offenders, so I wrote a new query for individual accounts. To do this I was using the MAX...
  6. Hollymc

    Where something "OR" something and something or...

    it runs but the actual query has 3000 lines of: c.sourceip between '4.2.145.0' and '4.2.145.63' OR c.sourceip between '4.2.170.64' and '4.2.170.127' OR and when it finishes it brings up IP's that are not between any of the IP's. My question then...Is my use of OR correct or no? The...
  7. Hollymc

    Where something "OR" something and something or...

    I thought I would impress my Father in Law by telling him I am a whiz at SQL. I'm alright but no whiz. These are IP's he wants to see if any of his clients are signing up from. He is diving into the world of CRM and I think he likes me more because I told him I could help. I figured or would...

Part and Inventory Search

Back
Top