Recent content by paalschau

But is the DCount formula also slow if it’s in a module/VBA. Any tips on how making it ?

I have tried this in a query - but the table is too big and the job takes ours… Could anyone help me with a function – that offer the same result? Tanks in advance :)

First tank’s antomack ! Now it’s almost right… (See last example below)… If [Uttr1] is like (4) – and if it’s just four customers - then four customers shod be returned – even if same number in [Uttr2]… Your functions returned 3 ?? If you manage this as well – the problem is solved… User...

I think this is the answer: DateSerial(Year(Date()), Int((Month(Date())-1)/3)*3+4,0)+1

I like your thinking – but I don’t wont “xx2 Nils Nilsen 1 538” to show… because the number in [Uttr1] = (1) for this user (the number of records to be retrieved for each user is determined by the number in [Uttr1]). This is my table: User Customer Uttr1 Uttr2 xx1 Ole Olsen 3 205 xx1 Ole...

That’s right! Out of this table: User Customer Uttr1 Uttr2 xx1 Ole Olsen 3 205 xx1 Ole Nilsen 3 450 xx1 Kari Karlsen 3 570 xx1 Hans Hansen 3 570 xx2 Per Persen 1 145 xx2 Nils Nilsen 1 538 I want this result: User Customer Uttr1 Uttr2 xx1 Ole Olsen 3 205...

Thanks for your interest in my problem – but the problem is still not solved… The problem is like Jon indicates – “The number of records to be retrieved for each user is determined by the number in Uttr1”… and Uttr2 if same number (se my previous explanations)… I need the result in a query...

Still needing help! Please :confused:

Hey Pat ! The result is not like expected… Your query2 shows: User Uttr1 MinUttr2 FirstCust xx1 3 206 Ole Olsen xx2 1 146 Per Persen I want this result: User Customer Uttr1 Uttr2 xx1 Ole Olsen 3 205 xx1 Ole Nilsen 3 450 xx1 Kari Karlsen 3 570 xx2 Per Persen 1 145 I...

I hope someone can help me with this... I have a query where I wish to show only rows like the number displayed in the column for [Uttr1] for current [User]. The query must display those rows with lowest sum in [Uttr2]. If number in [Uttr2] is equal to another row for this user - it shall...

Thanks for your input and help! This works great!

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