Re: Criteria

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: idontgetit (idontgetit_at_discussions.microsoft.com)
Date: 03/14/05 

Date: Mon, 14 Mar 2005 11:35:02 -0800

Thank you very much for your help, however it's not working for me and I'm
not a computer goo roo at this stuff so thanks for being patient with me.
When I type in "In ([Store #?])" in the criteria, it will ask me for the
store # which is good, but I want it to let me type in a couple store
numbers. I tried typing 5.6.7.8 in the box, but that doesn't work. Is there
a way of typing the input with "."";" or "/" to determine different values?

"John Vinson" wrote:

> On Mon, 14 Mar 2005 07:51:04 -0800, "idontgetit"
> <idontgetit@discussions.microsoft.com> wrote:
>
> >Is it possible to choose more than one value in the same field using the
> >"AND" criteria. For example: I have a listing of store #'s in one field and
> >a map of that store number in another field. I want to type store # 5.6.7.8
> >and 9 and have the query pull all 5 of those stores. What do I type as the
> >criteria?
> >Thank you VERY much!
>
> AND and OR are *NOT* English language conjuctions: they are Boolean
> logical operators. X AND Y is TRUE if both X and Y are TRUE
> expressions; if either is FALSE then X AND Y evaluates to FALSE.
>
> A query criterion is a logical expression; if it evaluates to TRUE
> then the record is retrieved, and if it's FALSE the record is skipped.
>
> So if you have [Store Number] = 5 AND [Store Number] = 6 you will
> never retrieve any stores, because for any individual record, the
> store number cannot possibly be equal to 5 and also equal to 6!
>
> Two suggestions: you can use OR criteria (i.e. retrieve this record if
> the store number is 5, OR the store number is 6); or you can use the
> IN() operator. Put
>
> IN (5, 6, 7, 8)
>
> on the criteria line and it will (again using OR logic) return records
> for any of the selected values.
>
> John W. Vinson[MVP]
>

Relevant Pages

  • Re: Criteria
    ... logical operators. ... never retrieve any stores, because for any individual record, the ... the store number is 5, OR the store number is 6); ... on the criteria line and it will return records ...
    (microsoft.public.access.queries)
  • Re: Date query
    ... If you only store the date part and only want to return records where the DueDate is the current date, set the criteria under DueDate to: ... 2010 and I want to retrieve everything from ...
    (microsoft.public.access.queries)
  • Re: Newbie help
    ... think I can probably get what I need using SQL Server (the ... > To efficiently store and retrieve data for your needs, ... You only store changed values (as ...
    (microsoft.public.sqlserver.programming)
  • Re: DOCX FILE CORRUPTED WHEN RETRIEVED FROM SQL2005
    ... I am facing the same problem and would appreciate your reply on the same as it has become a show stopper for me now. ... My Code is given below to retrieve the docx content from SQL 2005 whose data type is image. ... Here is the code where i insert the file into database. ... when I store these files to the server, using the code below and similar ...
    (microsoft.public.office.developer.vba)
  • Need to refresh page after calling showModalDialog
    ... I have Search form that allows users to retrieve records into a ... criteria thus selected. ... controls on the form remain unchanged. ...
    (microsoft.public.dotnet.framework.aspnet)