If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
In()
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?? -- Learning SQL and Access |
#2
|
|||
|
|||
In()
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 "stephenson22" wrote: 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?? -- Learning SQL and Access |
#3
|
|||
|
|||
In()
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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "stephenson22" wrote in message ... 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?? -- Learning SQL and Access |
#4
|
|||
|
|||
In()
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 "stephenson22" wrote in message ... 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?? -- Learning SQL and Access |
Thread Tools | |
Display Modes | |
|
|