Parameter Query / Field Criteria

Petros

Registered User.
Local time
Today, 10:37
Joined
Jun 30, 2010
Messages
145
Hi all,
In a query i am referring to form A, were two unbounded controls represent first and last date
Controls DateStart and DateEnd
The criteria in the query field "Date" is Between [First Date] and [Last Date]
How do i refer to control “DateStart”/[First Date] and “DateEnd”/[Last Date] in Form A?
I hope i managed to make myself well understood
Thanks!
 
Very much appriciated John..i used this as criteria and it works fine
Between [Forms]![Reports Menu]![FromDate] And DateAdd("s",86399,[Forms]![Reports Menu]![EndDate])

I tried to add some reputation to you...but seems i need to "distribute" some ?

Any ways..Thanks a Lot!
 

Users who are viewing this thread

Back
Top Bottom