Re: If this or that??

Yes thank you very much.. I totally forgot about and how to use "or" thanks
for taking the time to work this out for me.
Michael

"John Spencer" <spencer4@xxxxxxxxxxx> ha scritto nel messaggio
news:43B290A0.72E7BCC5@xxxxxxxxxxxxxx
> This will show records where any one of the fields is true (checked). Is
> this
> what you want?
>
> SELECT [Registro Entrate].Fornitore, [Registro Entrate].Del, [Registro
> Entrate].Prodotto, [Registro Entrate].RintracciabilitàLotto, [Registro
> Entrate].Marciume, [Registro Entrate].PresenzaDiErbeInfestanti, [Registro
> Entrate].AnomalieSulleFoglie, [Registro Entrate].Peronospora, [Registro
> Entrate].AnomalieSulleFogliesesiquali
> FROM [Registro Entrate]
> WHERE [Registro Entrate].Marciume = True
> or [Registro Entrate].PresenzaDiErbeInfestanti = True
> or [Registro Entrate].AnomalieSulleFoglie = True
> or [Registro Entrate].Peronospora = True
> ORDER BY [Registro Entrate].Del;
>
> Michael wrote:
>>
>> I need to make a query that says if any of the following fields have a
>> value
>> list them. Below is the sql without the filter.
>>
>> I need to know if any of the following feilds (check boxes) are checked ,
>> show the record in the query
>>
>> [Registro Entrate].Marciume, [Registro Entrate].PresenzaDiErbeInfestanti,
>> [Registro Entrate].AnomalieSulleFoglie, [Registro Entrate].Peronospora,
>>
>> thank you
>> Michael
>>
>> SELECT [Registro Entrate].Fornitore, [Registro Entrate].Del, [Registro
>> Entrate].Prodotto, [Registro Entrate].RintracciabilitàLotto, [Registro
>> Entrate].Marciume, [Registro Entrate].PresenzaDiErbeInfestanti, [Registro
>> Entrate].AnomalieSulleFoglie, [Registro Entrate].Peronospora, [Registro
>> Entrate].AnomalieSulleFogliesesiquali
>> FROM [Registro Entrate]
>> ORDER BY [Registro Entrate].Del;


.

Relevant Pages

  • Re: List Box Display Anomaly
    ... Michael, since it works fine on one machine but not on the other, you are looking to pin down the difference. ... There were some bugs introduced by SP3 for Office 2003, including combo display problems: ... All of a sudden, the columns from one of the tables is not displaying in the list box, but if I run the query in the query window, all the columns return data. ... I delivered a new front-end to a client this morning and he alerted me the anomaly. ...
    (microsoft.public.access.forms)
  • RE: calculated member question -- why (null)?
    ... why would a calculated member with a constant value ... "Michael D." ... ROWS FROM [Adventure Works] ... (My actual query is still slightly ...
    (microsoft.public.sqlserver.olap)
  • Re: equation in form wont equal
    ... query using dlookup- though I read somewhere to stay away from dlookups... ... "Michael J. Strickland" wrote: ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: concatenating problem when hyphenated first name
    ... And it's neat that you can enlist Access to help you understand what's happening, like the calculated query field giving the character count, or using TypeNameor the Immediate Window ... Allen Browne - Microsoft MVP. ... >> Paste the SQL statement here. ... Michael" without erasing the first Michael. ...
    (comp.databases.ms-access)
  • Re: Slow during Inserts
    ... Do you have any indexes or primary keys defined on these tables at all? ... your query performance will degrade considerably without ... Michael C#, MCDBA ... > FETCH NEXT FROM state_cursor ...
    (microsoft.public.sqlserver.server)