sql for dates to be given by day

[capdownlondon]

i have a graph, and it is based on sql to generate its values.

TRANSFORM Sum(redscount2.[CountOfCard Code]) AS [SumOfCountOfCard Code]
SELECT (Format([fldDate],"dd mm yy")) AS Expr1
FROM redscount2
WHERE (((redscount2.[Childs Name])<>"False"))
GROUP BY (Year([fldDate])*12+Month([fldDate])-1), (Format([fldDate],"dd mm yy"))
PIVOT redscount2.[Card Code];

this generates a graph and the x-axis displays all the dates from the fldDate field, but what i would lke it to do instead is to still plot every date, but instead have the dates running along the x-axis with a value for each day, where it have a record or not, but only plot based on the records fldDate values.

can anyone please help.

thanks
adam