A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

In()



 
 
Thread Tools Display Modes
  #1  
Old November 1st, 2006, 03:02 PM posted to microsoft.public.access.queries
stephenson22
external usenet poster
 
Posts: 31
Default 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  
Old November 1st, 2006, 03:54 PM posted to microsoft.public.access.queries
Barry Gilbert
external usenet poster
 
Posts: 379
Default 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  
Old November 1st, 2006, 04:06 PM posted to microsoft.public.access.queries
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default 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  
Old November 8th, 2006, 12:28 AM posted to microsoft.public.access.queries
Michel Walsh
external usenet poster
 
Posts: 2,404
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.