Search results for query: *

I agree that Access is a SQL system but it's limited with some functions comparing to other software's. I dont wan't time max or min what i need it's a breakdown of visits(count) and qty (sum). Unfortunately the PARTITION function can't remove duplicated visits before the count... The main...

Ok, but it will count "Visit" A124 as two separate visits where it's this same only with different times. Sorry for the question but i'm pretty fresh with Access and i can't migrate to any proper SQL system.

The orders table is as below, ID Visit Product Time Date_Visit Qty 1 A123 123 13:34:13 18/05/2011 3 2 A124 143 16:05:13 03/04/2011 1 3 A124 193 07:23:19 03/04/2011 9 4 A126 137 06:59:01 13/07/2011 4 5 A127 139 11:06:12 11/04/2011 3 6 A127 129 11:06:12 11/04/2011 1 7 A129 121 13:59:01...

It's still not working as you have duplicated visits, It's the information received from the query and as you can see we have two situation when this same visit is counted twice. Range_Time Visits Total_Qty 6: 6 1 4 7: 7 1 9 11:11 2 4 13:13 2 8 16:16...

Hi, I'm a new Access user and i'm having some small problems with pulling out the information from Microsoft Access database. I need a breakdown of unique visits by specific time range. Below function is working fine as it give me the breakdown by time unfortunately the duplicated visits...