I have a query that shows this:
User customer
xx1 Hans Hansen
xx1 Ole Olsen
xx1 Kari Karlsen
xx2 Nils Nilsen
xx2 Per Persen
I wont to use a query to count the total for user and still use the Group By function.
Like this:
User customer counts
xx1 Hans Hansen 3
xx1 Ole Olsen 3
xx1 Kari Karlsen 3
xx2 Nils Nilsen 2
xx2 Per Persen 2
Is it possible to not use SQL…
I don't want it in a report because I need to use the info for further querying.
Thanx...
User customer
xx1 Hans Hansen
xx1 Ole Olsen
xx1 Kari Karlsen
xx2 Nils Nilsen
xx2 Per Persen
I wont to use a query to count the total for user and still use the Group By function.
Like this:
User customer counts
xx1 Hans Hansen 3
xx1 Ole Olsen 3
xx1 Kari Karlsen 3
xx2 Nils Nilsen 2
xx2 Per Persen 2
Is it possible to not use SQL…
I don't want it in a report because I need to use the info for further querying.
Thanx...