Wild Card in query criteria

[drschlong]

Hi all,

This may sound like a really stupid question but my brains frazzled at the moment and I can't seem to find anyway to solve this problem.

In one of my queries I am performing a search on a date field, in the form of:-

Between [Enter Start Date] And [Enter End Date].

All pretty simple so far I think you would agree.

What I need to do now is modify the criteria so that if a user enters say the 13/09/02 as the start date, the query will search for this date and any other information in the field after it. i.e. the system we are performing the search on sometimes enters not only the date into this field but also the time as well at the end. I have tried using the * as wildcard in different ways but I can't seem to get it to work.

Any help would be much appreciated.

Thanks in advance.

Steven.

 

[Sohaila Taravati]

Put this critaria in your query:
>=[Enter Date Please]
So if the user puts in 9/1/02, it will show all the dates from 9/1/02 on

 

[CJBIRKIN]

Hello

As far as i am aware ( and i've tested this) any date selected as a crtieria will work equally as well with date fields and date and time fields

i.e if you had two data points written as

09/06/2002 and 09/07/2002 10:35

a statement of

between#09/06/2002# and #09/07/2002# would select both records

Chris

 

[drschlong]

I don't think any of these will work.

I am trying to do something like this:-

Between [Please Enter Start Date]* And [Please Enter End Date]*

I hope this makes better sense. The asterix would then allow the search to find records where there was just a date and where there was a date and time in the field.