< In()

S

stephenson22

How can I use the "< or <=" operator(s) in this situation

<(In(select [dateField] from [tbl_dates]))

I want to circle tha values in a table (which I can do) but use the boolean
operator as a filter condition.

The normal method would be:

<#01/11/2006#
then another iteration of
<#01/10/2006#

Can anyone help??
 
B

Barry Gilbert

IN returns a boolean, so I don't think this would work. I think you just want
a simple join to find the records in one table that have equal values in
another. Is this what you're looking for?

Barry
 
J

Jeff Boyce

One approach would be to "chain" queries. First, do a query that returns
the dates from tbl_dates. Then create a second query, based on the first
query plus the table from which you wish to select based on those dates -
join them on the dates fields.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
M

Michel Walsh

Hi,



x IN(SELECT y FROM z)

can be translated into

x = ANY(SELECT y FROM z)


so, I assume you may want to try

x <= ANY( SELECT y FROM z)


Hoping it may help,
Vanderghast, Access MVP
 
Top