[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
>