[nasos23]

Καλημέρα σε όλους.
Γιώργο για το ερώτημα

SELECT tblCustomers.[Customer No], tblCustomers.FirstName, IIf(IsNull([Lastname]),IIf(IsNull([FirstName]),[FirstName]),
IIf(IsNull([FirstName]),[Lastname],[FirstName] & " " & [Lastname])) AS [Contact Name], 
tblCustomers.[Home No], tblCustomers.[Work Phone], tblCustomers.[Mobile No],
 tblCustomers.[Date of Birth], Giortazoun([Date of Birth]) AS Ειδοποίηση
FROM tblCustomers
WHERE (((Giortazoun([Date of Birth]))<>" "))
ORDER BY IIf(IsNull([Lastname]),IIf(IsNull([FirstName]),[FirstName]),IIf(IsNull([FirstName]),
[Lastname],[FirstName] & " " & [Lastname])), Giortazoun([Date of Birth]);

Επίσης μία άλλη προσέγγιση δες εδώ:http://www.ms-office.gr/forum/access...ymiseis-2.html ίσως σ' εξυπηρετεί.