[AccessD] query select in column

pedro at plex.nl pedro at plex.nl
Thu Dec 29 12:55:41 CST 2011


Dear list.

i have a table with patients.

tblDialysis

Pat      OpenDate      Code
1        01-01-2011    325
2        02-02-2011    325
2        03-03-2011    326
2        04-04-2011    327
3        05-05-2011    325
3        06-06-2011    326
4        07-07-2011    325
4        08-08-2011    327
5        09-09-2011    326

i need all records of patients who have a code 325 and 326  0r 325 and 327


result

Pat      OpenDate      Code
2        02-02-2011    325
2        03-03-2011    326
2        04-04-2011    327
3        05-05-2011    325
3        06-06-2011    326
4        07-07-2011    325
4        08-08-2011    327

any idea's

Pedro




More information about the AccessD mailing list