hey guys, what's the more efficient way to find which date in a date range a table doesn't have records?
the context is - i'm building an attendance table.
so i've got a start date in a table, and my end date is today.
so staff will have to fill in the work hours for each day.
sometimes they will miss out saturdays or sundays or thursday for example. i want to make sure EVERY DAY IS FILLED IN.... MUAHAHAHAHA!!! so draconion isn't it!!!!! hahaha = PP
Question) what is the best way of doing it?
preference 1: i preferably want to use SQL
preference 2: i preferably don't want to have a table that i maintain calendar days or numbers in it for this to work.
preference 3: i would like to use super sexy SQL code that proves to myself that SQL is super duper powerful. cause i want to think in data sets.
i can use VBA no problems at all but it's very.... p r o c e d u r a a aa..aaaaa.aaa. l. oops! procedural programme malfunction!! haha = ))
thanks guys!! = )))