Use criteria to fill in date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way I can tell Access to do the following:

Look at table1 for a record with an employee name for a specified date, if
the employee name is not listed for that date add the employee name and date.
A list of Employee names will be in table2. The general idea is that
employees must have an entry for every day in table1, if there is not an
entry I need to add one.

Thanks
 
Is there any way I can tell Access to do the following:

Look at table1 for a record with an employee name for a specified date, if
the employee name is not listed for that date add the employee name and date.
A list of Employee names will be in table2. The general idea is that
employees must have an entry for every day in table1, if there is not an
entry I need to add one.

Thanks
Click to expand...

There are many ways to do it, but something doesn't sound right. Can
you give a better description of what you are trying to accomplish? A
table with every conceivable date for each employee seems pointless.
How is the date related to the employee? When is the employee/date
record added? What is it to be used for?
 
You can create a query to give you this results. Use the Unmatched query
wizard. It will guide you through creating it.
 
Back
Top