Help with Like & "*" parameter... (1 Viewer)

[The_Vincester]

I've got a number of tasks that are set up throughout the day, I would like to be able the tasks between the two times, but can't seem to get this to work. This is a query based on three parameters.

[Name:]
[Team:]
and
Between [Time1:] and [Time2:]

I can use the Like [Name:] & "*" on the first two parameters to see everything, but I can't seem to use:

Like (Between [Time1:] and [Time2:]) & "*"

to see all the times involved. How can I do this?

 

[EMP]

This thread may help.
http://www.access-programmers.co.uk/forums/showthread.php?t=115783

^

 

[The_Vincester]

This thread may help.
http://www.access-programmers.co.uk/forums/showthread.php?t=115783

^

Nope, didn't help. Thanks though. I still can't figure this one out.

 

[gemma-the-husky]

you are ok using like on the text fields

in the date field just put

between [Start Date] and [End Date] (or whatever text you want in the prompts.

This will pop up 2 input boxes to get the parameter and then run it. You don't need the like with dates (or numbers incidentally)

Using query line parameters isn't exactly the best way to get parameters into queries, but its ok for rough and ready stuff.

Why not the best? - Well you can't go back and change parameters if you make a mistake. You can't validate the parameters as you enter them. Its an inelegant way of doing it.