In doing the homework for this lesson I ran into a problem with the Make Table Query to make a back up of the Order Table. I had an error message telling me that I could not make a table that included a calculated field. I got around it by not including the DaysToShip field in the back up table. My work around would obviously involve a need to reinstate the DaysToShip field later but I couldn't see a way of including that adjustment in the macro.
If the DaysToShip is calculated from other fields, could you not just make a new Query with the Backup table and recalculate there?
Greg MillerOP
@Reply 15 months ago
Thanks Alex, I was hoping that there might be a solution that did not involve making yet another query. I see that in Access 17 Richard's solution is to delete the calculated field from the Order Table on the grounds that calculations of the type in the DaysToShip field in the Order Table can quite easily be done on the fly and so the DaysToShip field is superfluous.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 16.
