Find missing Working Days

My database needs a record entering for every working day. A working day is
defined as every day from Monday to Friday. This includes Bank Holidays and
other holidays, so at least that bit isn't a problem
Can anyone think of a query that can check if any days are missing? eg one
week I didn't enter a record for Tuesday? I suspect the answer will have
something to do with DatePart but I can't figure out how to find the missing
numbers. ie the

I suppose that I could cycle through the record with VBA and print the
results into a table if a number from 1 to 5 is out of sequence but I wonder
if it could be done with a query.

It wouldn't matter if the query also returned the results for the week I ran
it, if the query was run half way through the week.

The datefield is called WkDate in TblWorkRecord.

Evi


.

Relevant Pages

  • Re: Custom Function in Query
    ... > I am converting a mdb to an adp with sql server 2000 backend. ... > Server Function but I would prefer to use a table to store the dates so ... It would be pretty easy to create a query which, ... all you need to do is to manually set the bank holidays for as far ahead as ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Statutory minimum holiday
    ... I suppose the query is best answered by ... posing the following example that is directly relevant to our ... He does not work, nor is paid for, any Bank Holidays ...
    (uk.legal)
  • Re: tempdb grows to 8G suddenly
    ... that a join predicate is missing. ... >> to someone running a query which has a join that has not been qualified ... a huge result set gets built up (in tempdb ...
    (microsoft.public.sqlserver.server)
  • Re: RM formalism supporting partial information
    ... omniscient database. ... If the user formulates a query then this will now ... If the age or occupation is missing we could ... the value-does-not-apply interpretation can always also be ...
    (comp.databases.theory)
  • Re: Understanding How Access Sorts Records
    ... Best use a query to reorder ... incomplete records being entered and as it turns out, they are missing ... the value that I would be sorting on. ...
    (comp.databases.ms-access)