Display date even if null (1 Viewer)

durdle

Registered User.
Local time
Today, 05:20
Joined
May 7, 2002
Messages
130
Good day,

I have a query that returns hours of vacation time taken for each specfic day of the year. But if no time is taken on for example Jan. 19th, that date do not show up in the query. I am wondering is it possible to return all 365 days and display a zero,if nothing is booked for that day.

Thanks

Chris
________
vapir no2
 
Last edited:

not a code fan

Registered User.
Local time
Yesterday, 21:20
Joined
Nov 21, 2004
Messages
32
I'm by no means an expert but i think this can be done by making the "default value" for the field in the design view of your table "0"

:)
 

Users who are viewing this thread

Top Bottom