code to add data to a blank field in a table
Posted on 2011-04-26
Next query for my Db.......
Db is 'comprised' of two main tables
1 contains most recent staff data
2 contains information entered by user based on the staff data (information that is not captured in staff data)
I have several queries that produce information by way of queries, reports, exports etc.
I have been bothered since the beginning of this process though.
When new staff data is imported, there is no information for 'new' staff in one of the fields within the second table....and as reports are run form queries using both tables, I need to know how to add the following to an exisiting field.
eg: Joe bloggs commences work...He has no performance agreement in place....All staff must have one within 2 months of commencing work...
How do I add (Last start date plus 2 months) to the field in the second table for joe so that his supervisor gets a report with the due date on it - instead of a blank
Obviously when there is an agreement in place, a review date will be in the field. I can do a seperate query to add this date but then how do I 'meld' the two fields to one....
as always, any help appreciated.....