Need a guiden for writing hard code !

L

luanhoxung

Hi all !
I need a help for write a odd code (I think :) ).
I have a field in my report with many values appearing many times, so
i count them and choose the max value, the result that i want it
return the initial text.
Pls see my desire

Text appearing--Result of DCount(text)--Result of Max--Result
returning
bag 1
10 pcs
pcs
10
tray
5
kg
2

I dont know much VB so i really be mad abt this throught last week.
Hope someone understand this,
Thanks for ur time visiting my problem.
Luan from VietNam
 
L

luanhoxung

Hi all !
I need a help for write a odd code (I think :) ).
I have a field in my report with many values appearing many times, so
i count them and choose the max value, the result that i want it
return the initial text.
Pls see my desire

Text appearing--Result of DCount(text)--Result of Max--Result
returning
bag 1
10 pcs
pcs
10
tray
5
kg
2

I dont know much VB so i really be mad abt this throught last week.
Hope someone understand this,
Thanks for ur time visiting my problem.
Luan from VietNam
Click to expand...

Sorry abt line be down !

Text--ResultofDCount(text)--ResultofMax--ResultReturning
bag 1 10
pcs
pcs 10
tray 5
kg 2

Regards.
Luan
 
2

2007

Hi all !
I need a help for write a odd code (I think :) ).
I have a field in my report with many values appearing many times, so
i count them and choose the max value, the result that i want it
return the initial text.
Pls see my desire

Text appearing--Result of DCount(text)--Result of Max--Result
returning
bag 1
10 pcs
pcs
10
tray
5
kg
2

I dont know much VB so i really be mad abt this throught last week.
Hope someone understand this,
Thanks for ur time visiting my problem.
Luan from VietNam
Click to expand...
 
2

2007

Hi all !
I need a help for write a odd code (I think :) ).
I have a field in my report with many values appearing many times, so
i count them and choose the max value, the result that i want it
return the initial text.
Pls see my desire

Text appearing--Result of DCount(text)--Result of Max--Result
returning
bag 1
10 pcs
pcs
10
tray
5
kg
2

I dont know much VB so i really be mad abt this throught last week.
Hope someone understand this,
Thanks for ur time visiting my problem.
Luan from VietNam
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

get the text string appear the most times ! 0
Get text of max in count of records ?? 1
Counting unique values in a report 9
Need A code for Visible/Hide base on Combo Box 14
SQL query is not working for Binary data!! 2
code help with do.. loop and dlookup in a report 4
Need help writing formulas for following functions - 4
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1

Top