pedro at plex.nl
pedro at plex.nl
Thu Sep 30 10:39:06 CDT 2010
Dear List, i have two tables tbl1 patientnr Afsluitdatum 01234567 01-01-2010 09876543 15-01-2010 tbl2 patientnr Uitvoerdatum 01234567 01-02-2009 09876543 01-01-2009 I would like as result a new table that subtracts UitvoerDatum from Afsluitdatum, and when the result is within 365 days, i need a "1" and when the result is more then 365 days, i need a "0". So the result is: patientnr days value 01234567 334 1 09876543 379 0 Normally i do this in Excell, but i would like to do everything in access and not part in access and part in excell. Thanks Pedro