sort by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a DB with multiple fields, that manage help calls.
One of the fields is CallDate.
In my form I have "From_Label" & "To_Lable" text boxes.
I want to sort the help calls between this dates.
for example, I want to get a list of all calls enterd to the DB from the
10/01/04
("From_Lable") to the 11/01/04 ("To_Lable").

I tried to use:
Between &[From_Label] And &[To_Label]

But I get an error saying " can't find the macro 'Between &[From_....' ".

Any ideas?

Thanks
 
Just wanted to be more clear.
I want to FILTER the DB according to "From_Lable" & "To_Lable".
 
You didn't indicate where you are using the Between ... And ... expression.

If in the criterion of a query, the criterion would also need to include a
reference to the form ... i.e., something like:

Between Forms!YourForm![From_Label] And Forms!YourForm![To_Label]

I am curious why you are calling a text box "From_Label" -- labels and text
boxes are not the same.
 
Back
Top