< In()

[Guest]

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??

 

[Guest]

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

 

[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/

 

[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