[AccessD] first five dates per year

Gustav Brock gustav at cactus.dk
Mon Mar 10 03:51:00 CST 2003


Hi Pedro And Drew

> thanks Gustav for your explanation. The dates where not unique.
> I used the Union All sql and now its working fine.

Very well.

Drew, I just used the date field from a test-table I have with 150000
records. I guess you can create your own table with this single
date/time field though the dates should not be random - some must be
duplicates.

> Drew, thanks for your offer, but i can't send You an example because
> the data is classified. From the management in our hospital
> and my boss i may not present Patientdata to other. Sorry, not even to
> a database developer who wants to help me.

/gustav




More information about the AccessD mailing list