Use an expression field in a criteria for a query

[saschmeling]

Hi,

I am building a Query that requires the following:

ID
Separation Date (this is a criteria field- to minimize the results)
Department (Criteria field to find an individual department)
Reason

This query will feed into a report. I am also using a form to feed the Department Criteria because the department names are very long. I would like the Separation Date to pull from the same form but give me a range such as:

Criteria:
Between [enter a start date] and [enter an ending date]

I would like the start date and ending date to pull the information off of the form.

For the Department- I used a simple statement: [forms]![formName]![fieldName] to get the criteria. This is not working for the between statement.

Does anyone have any suggestions?

Thanks in advance.
Scott

 

[BrianMH]

Have you formatted the textbox on the form to date? I'm not sure if that is necessary but it can't hurt.

Between [Forms]![formname]![objectname1] And [Forms]![formname]![objectname2] should work. When you say it isn't working is it giving you an error or just not giving the results you expect?

 

[saschmeling]

Have you formatted the textbox on the form to date? I'm not sure if that is necessary but it can't hurt.

Between [Forms]![formname]![objectname1] And [Forms]![formname]![objectname2] should work. When you say it isn't working is it giving you an error or just not giving the results you expect?

Must have been typos on my part- not sure what I did but when I used the expression builder with >= and <= it worked perfectly fine.

Thanks for the info.