? about a userform

[dok112]

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

[Leith Ross]

Hello Dok112,

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

Sincerely,
Leith Ross

[dok112]

Sorry...it's a Microsoft Access DB.

[dok112]

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