Wenn ein Kind Geburtstag hat, dann wird dies im Ausleihfenster mit einem kleinen Icon angezeigt:
Eine Liste mit allen Geburtstagen kann als
eigene SQL-Abfrage erfasst werden:
SELECT Adressen.ADRNR, Adressen.ENDDAT AS [Abo bis], Adressen.NACHNAME AS Familienname, JgKind.KNDVORNAME AS [Name Kind], JgKind.JGKIND AS Geburtstag, DateDiff("yyyy",[JGKIND],Date())-IIf(Month(Date())<Month([JGKIND]),1,IIf(Month(Date())=Month([JGKIND]) And Day(Date())<Day([JGKIND]),1,0)) AS [Alter], IIf(DateSerial(Year(Date()),Month([JGKIND]),Day([JGKIND]))<Date(),DateDiff("d",DateAdd("yyyy",-1,Date()),DateSerial(Year(Date()),Month([JGKIND]),Day([JGKIND]))),DateDiff("d",Date(),DateSerial(Year(Date()),Month([JGKIND]),Day([JGKIND])))) AS [Tage bis Geburtstag]
FROM Adressen INNER JOIN JgKind ON Adressen.SYSADRNR = JgKind.SYSADRNR
GROUP BY Adressen.ADRNR, Adressen.ENDDAT, Adressen.NACHNAME, JgKind.KNDVORNAME, JgKind.JGKIND, DateDiff("yyyy",[JGKIND],Date())-IIf(Month(Date())<Month([JGKIND]),1,IIf(Month(Date())=Month([JGKIND]) And Day(Date())<Day([JGKIND]),1,0)), IIf(DateSerial(Year(Date()),Month([JGKIND]),Day([JGKIND]))<Date(),DateDiff("d",DateAdd("yyyy",-1,Date()),DateSerial(Year(Date()),Month([JGKIND]),Day([JGKIND]))),DateDiff("d",Date(),DateSerial(Year(Date()),Month([JGKIND]),Day([JGKIND]))))
HAVING (((JgKind.JGKIND) Is Not Null))
ORDER BY IIf(DateSerial(Year(Date()),Month([JGKIND]),Day([JGKIND]))<Date(),DateDiff("d",DateAdd("yyyy",-1,Date()),DateSerial(Year(Date()),Month([JGKIND]),Day([JGKIND]))),DateDiff("d",Date(),DateSerial(Year(Date()),Month([JGKIND]),Day([JGKIND]))));
Dies zeigt dann die folgende Tabelle an: