J
JasonS
Hello!
Please, help with this....
I created a form in which there are two Calendar controls (ActiveX1 and
ActiveX2), a text box a button.
The calendars are used to set a beginning and ending date of a average
query.
This is the action set for onClick button's event :
Dim k As Variant
k=DLookup("AVG[g]","[Table1]", "[Date] BETWEEN Forms![Form1]![ActiveX1] AND
Forms![Form1]![ActiveX2]")
Me.TextBox.Value=k
But it seems like I created some kind of Frankenstein because there are only
errors I get as a result
Please, can enybody tell me how to retrieve an average value based on given
by user conditions (e.g. period of time) and then put it as a value of a
texbox?
Thank you in advance
Greetings from Poland
Please, help with this....
I created a form in which there are two Calendar controls (ActiveX1 and
ActiveX2), a text box a button.
The calendars are used to set a beginning and ending date of a average
query.
This is the action set for onClick button's event :
Dim k As Variant
k=DLookup("AVG[g]","[Table1]", "[Date] BETWEEN Forms![Form1]![ActiveX1] AND
Forms![Form1]![ActiveX2]")
Me.TextBox.Value=k
But it seems like I created some kind of Frankenstein because there are only
errors I get as a result
Please, can enybody tell me how to retrieve an average value based on given
by user conditions (e.g. period of time) and then put it as a value of a
texbox?
Thank you in advance
Greetings from Poland
)