Sorting date in a database

[bilal]

in microsoft access if we create a database of every day of a month and if some dates are missing in data for example if 19th and 20th june is missing in the month of june. How can we sort the missing sequence i.e. we want to know which dates are missing?

[JoeM]

One way would be to create a table of all the possibles days of a month, i.e. 31 records, one for each day.
Then do an unmatched query between these table and your data, looking for missing days.

If you really want to get precise, you could make a tables like this for the whole year, if you are matching on a complete date field (and not a day number field).
This is easier than it sounds. You can create all the dates in Excel pretty easily, but entering the first day of the year, then adding one down for each row until you get to the last day of the year. Then import that data into an Access table.

[bilal]

Thanks buddy