MS Access Problem Adding Multiple Criteria in a Query

[russm101]

I am attempting to add the "Between Date" and ="value" expression in a query. Only one of the query are working at a time. Is there a way to add them both. I even tried on as an "or". Still Not Working!

Any ideas!


Thanks....Russ

 

[THWatson]

Russ
I'm not exactly clear what "value" is.

Is "value" a date? So that you are trying to pull records which are "Between Date And value"? In this case, Date would be today's date, and "value" would be some other date.

In any case, your expression "Between Date" and ="value" will never work.

Tom

 

[russm101]

Thanks for the quick response!

What I mean by =value is that value is the match of my criteria selection.

example:

If:
Criteria expression says ="cool" for one column

Can I enter "Between Date() and Date()-7" in another criteria of a deifferent column in the same query.


once again, thanks....

 

[THWatson]

Russ
Yes, that should work. What that would do first is select all records which have "cool" in the one column, and then of those records select the ones which are "Between Date() And Date()-7)"

What happens when you run the query?

If things still don't work properly, you could post the SQL for the query.

Tom

 

[russm101]

Thanks..

When I do this, I don't see any records even though there is data that meets tboth criterias. If I do either of them by themselves, the records show up.

Russ

 

[THWatson]

Russ
Two questions...

1. Is this query based on one table only? Or on two tables joined in a one-to-many relationship?

2. Can you copy the SQL and paste it here?

Tom