? about a userform
 

Quick question for you guys...I have a userform, that has 2 textboxes on
it...the user is going to enter a date into both boxes. I need help
creating a macro that will connect to a database, and query the db for
anything btwn those dates in the specified table. I don't need to copy
this info, I just need to temporarily isolate it from the rest. What
i'm needing from that data, is to then have a label on the userform
that is going to average the scores from those dates.

IE.
textbox1.value = 10/01/2001
textbox2.value = 10/30/2001

Using these dates, query the table 'Results' for any rows that are
within this date range. Then on the userform, I need label1.caption =
'the average of all entries in "Q1" of Table "Results"...'

anyone have any idea's of how to do this? I really appreciate the help
:)


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=478130

? about a userform
 

Hello Dok112,

It would help to know what type of database you are working with.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=478130

? about a userform
 

Sorry...it's a Microsoft Access DB

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=47813

? about a userform
 

does anyone have any ideas of how to do this? Any help is GREATL
appreciated

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=47813