I have tried to build an sql query to use in a Query Table.

It should be - select * where data = x or data = y and date <= date1 and =
date2

what it appears to be doing is querying the date on data y but not on data
x, if that makes sense.

How can I select by two data types and then dates on all data selected???

Logical "AND" is always performed before logical "OR" operators, therefore
your statment is working as if written like this:

where data = x or (data = y and date <= date1 and = date2)

try doing this:

where (data = x or data = y) and date <= date1 and = date2



"westg" wrote:

I have tried to build an sql query to use in a Query Table.

It should be - select * where data = x or data = y and date <= date1 and =
date2

what it appears to be doing is querying the date on data y but not on data
x, if that makes sense.

How can I select by two data types and then dates on all data selected???

Also, it looks like something is missing...

where (data = x or data = y) and date <= date1 and DATE = date2


"Charlie" wrote:

Logical "AND" is always performed before logical "OR" operators, therefore
your statment is working as if written like this:

where data = x or (data = y and date <= date1 and = date2)

try doing this:

where (data = x or data = y) and date <= date1 and = date2



"westg" wrote:

I have tried to build an sql query to use in a Query Table.

It should be - select * where data = x or data = y and date <= date1 and =
date2

what it appears to be doing is querying the date on data y but not on data
x, if that makes sense.

How can I select by two data types and then dates on all data selected???

Hi westg,

You may have to use parenthesis to group the items in your where clause:

SELECT *
FROM MyTable
WHERE (Data=x OR Data=y)
AND MyDate<=Date1
AND MyDate=Date2


--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


westg wrote:
I have tried to build an sql query to use in a Query Table.

It should be - select * where data = x or data = y and date <= date1
and = date2

what it appears to be doing is querying the date on data y but not on
data x, if that makes sense.

How can I select by two data types and then dates on all data
selected???

I also have the same confussion, give me some idea about berween date
query

*** Sent via Developersdex http://www.developersdex.com ***