murray83
Games Collector
- Local time
- Today, 23:38
- Joined
- Mar 31, 2017
- Messages
- 728
so have a front end which is just used to find and open a PDF file, bit quicker and better looking then searching through file upon file.
but have come upon a question that I'm sure can be answered by you smart lot, have searched here but didn't find anything on the subject.
but what i would like is a query which looks at the main data, selects the distinct Dt ( my date field name as cant use Date and sounds similar) and then display missing dates.
so far have just done a little SQL which has as hoped pulled the Dt out
but how would i make it look for missing dates, am i going to need a table with each day for the whole year ??
but have come upon a question that I'm sure can be answered by you smart lot, have searched here but didn't find anything on the subject.
but what i would like is a query which looks at the main data, selects the distinct Dt ( my date field name as cant use Date and sounds similar) and then display missing dates.
so far have just done a little SQL which has as hoped pulled the Dt out
Code:
SELECT DISTINCT Main.Dt
FROM Main
ORDER BY Main.Dt ASC ;
but how would i make it look for missing dates, am i going to need a table with each day for the whole year ??