[AccessD] query

Hello Arthur,

thanks,
i will try this out tomorrow at work

Best Wishes

Pedro


----- Original Message ----- 
From: "Arthur Fuller" <fuller.artful at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, December 23, 2009 3:47 PM
Subject: Re: [AccessD] query


> Of course you can!
>
> SELECT PatID FROM myTable
> WHERE Diag = "Coeliakie" AND Immuno = "IgA" AND Date > Date() - 30 AND
> Mateerial = "Duodenum".
>
> If you're using SQL Server, substitute the double quotes with single 
> quotes.
>
> hth,
> Arthur
>
> On Wed, Dec 23, 2009 at 8:19 AM, Pedro Janssen <pedro at plex.nl> wrote:
>
>> Hello Group,
>>
>> i need to filter out Patients [PatID] with the diagnosis [Diag] =
>> "*Coeliakie*" and Immunology [Immuno] = "IgA" and have undergone a new
>> examination, within a month [Date], where the sample [Materiaal] =
>> "Duodenum"
>>
>> Normally i do these with several query's etc.
>>
>> Can i do this in one?
>>
>> Thanks
>>
>> Pedro
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>