Calculating transactions by time

  • Thread starter Thread starter sabunim
  • Start date Start date
S

sabunim

Here's my problem, I have customer transaction data that shows deposits and
withdrawals for a month. My data includes the customer ID, type of trans,
date of trans, time of trans and amount. I am trying to come up with a way
to count the number of times a customer makes a deposit then immediately
makes a withdrawal. Obviously this will occur on the same date and within a
minute or less of the deposit. I can pull a query showing the two relevent
transactions together in a table but how do I count the number of
occurrences. Any help is appreciated. Thanks!
 
SELECT COUNT()
Look it up in Help.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Have you checked to see if the Totals query can do the calculating you need?
Try the Count aggregation...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Excellent! I followed your thought process, tweaked it a bit and got it work
for me. Thank you!
 
Back
Top