Parameter Query forms

[FreddyFordo]

Problem.

I have a query with the following.

JOB ID - INVOICE A DATE - INVOICE B DATE - INVOICE C DATE

I want to pull off a report where any of the invoice dates fall between a certain criteria. So far I have this where a form drives the query.

Between [Forms]![Form]![Text_Enter_Date_From] And [Forms]![Form]![Text_Enter_Date_To]

This doesnts take into account all 3 fields and actually doesnt even work for one.

Help!

[June7]

Put the criteria under each column on separate OR lines.

Why doesn't it work - error message, wrong results, nothing happens?

Your form is actually named Form?

[FreddyFordo]

Yeah, my form is called form, its just to test it out.

The query doesnt return anything and Ive checked the correct dates and the date formats in the entry field from my table and the form to make sure they are the same.

Attached is a screendump.

[June7]

I suspect issue is with the criteria under the text fields.
Are you using wildcard with LIKE? LIKE needs wildcard else might as well not be used.

Post the sql statement.

Is the date range required or do you want to be optional criteria?

[FreddyFordo]

Here is ths sql statement.

Between [Forms]![Form]![Text_Enter_Date_From] And [Forms]![Form]![Text_Enter_Date_To]

Ive also got a Like function in the project field where I want to return records from a particular project.

Like nz([Forms]![Form].[Text_Enter_Project],"*")

Has it anything to do with the fact Ive linke an excel spreadsheet to a query. Ive checked and the date formats are the same.

Thanks.

[June7]

That is not complete SQL statement. See the SQL statement in SQL VIEW.

Including Excel table link in query should be okay.

The LIKE expression should be:
Like [Forms]![Form].[Text_Enter_Project] & "*"