Problem finding various information by inserting two dates 1

[0200050]

Hello everybody!

Firstly i'd like to give some details of the problem.

I have a form, where are two textbox fields, Time1 and Time2. User inserts two dates at this form. First date to Time1, and second to Time2.

Now i'm searching for more information about the following action:

When the dates are typed, there will be a command button waiting to be pressed. When this button is pressed, the program will find various information from the tables, and displays them on the form. The way the information are displayed, is the interval given between Time1 and Time2.

So for example, if (Time1 = 23.3.2004) and (Time2 = 24.3.2004) the program would display only records that have been modified during this interval.


I'm a bit uncertain how to start to build this property. If you would have some suggestions about this, please share your knowledge, and it will be thankfully appreciated.

Thank you in advance!

Mike, from finland

 

[mrf1xa]

Hi Mike

Create a query based on your tables and including all the fields you need.Include your date field, and in the criteria for this field use 'Between Forms![Nameofyourform]![Time1] And Forms![Nameofyourform]![Time2]'.

Now you can base your form or report on this query, and run it when you click the button.

Hope this helps

Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

 

[0200050]

Hello Nigel, and thank you for your very helpful reply!

This query is nice, but do you Nigel, or someone else, have an idea how to apply this query to a subform?

Mike, from finland