I'm not even sure if this is possible but here goes....
I have a Training table which has a boolean (Field named "Add") yes/no field that I will check if people attended and I have an update query that puts all relevant info into my final table. I had this set up so that if I checked yes it would then move the relevant info from the table into my final table AgentRecords.
I had everything working fine until I was told I needed to have dates missed entered into my final table so I've created two additional tables called Completed Date and Date MissedA and what i'm wondering is this: Can I do some sort of IF Else statement in the criteria field of the append that says if (the boolean field)add <>0 put under Date MissedA else Date Completed?
Any help is appreciated and I did leave out why I went this route and could explain further if need be but this is my first database and every so often I'm hitting some barriers as some of this just isn't covered in my books or easy to find in google or should I say decipher.