Hi Sofia
You might check out the FREQUENCY and HISTOGRAM functions in Excel help.
They look to be similiar to the Partition VBA function that you are using,
judging by the description of Partition in VBA help. (I have never used
Partition)
Please note that the HISTOGRAM function is only available with the Aalysis
ToolPak loaded.
You obviously know how to use Access, but I do not know how familiar you are
with Excel, so if you need a general discussion of using statistical
functions in Excel, please see:
http://office.microsoft.com/training...RC010919231033
for information on how to use Excel statistical functions.
Please let us know if this helps or if you need clarification or further help.
SongBear

" wrote:

Hi, I working with some macros in Excel and i need to consult a DB in
Access. Does anybody know how can i do that?? and, besides the
consulting, how can i actualize one record, or how to move that
information into TextBox that i have in Excel??
I'll be waiting your answer!!
bye