troubleshooting Question

Building Query in Access 2010 to find sequential transactions

Avatar of mobdog
mobdogFlag for United States of America asked on
Microsoft AccessSQL
4 Comments1 Solution295 ViewsLast Modified:
     1. Have table of 10,000,000 Customers [ customer name, customer #, transaction date, salesperson ]
      2. Have table of 10,000 customer invoices - relevant fields are: [transaction#, transaction_type, transaction date, customer_name, salesperson ]
      3. Have table of 1,500 customer return invoices - fields[transaction#, transaction_type, transaction date, customer_name, salesperson]
      4. Definition of transaction# - every record has a unique ascending transaction# and every transaction# is created in sequential order and defined by the [transaction_type]
      I'm looking Query those tables for the following info:
      5. Find all transactions where [customer_name ] had a [transaction#] within 10 numbers of another [transaction#] of the same customer.

I am also looking to find sequential transactions with the same customers. i.e. all situations where a customer transaction# is within 1 of another.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros