Hi,
I am a beginner user developing an access system for my children's entertainment company. Since we are getting much busier, I am creating a database where we can log bookings and enquiries and manage customer relations.
The data entry form that the sales team will be using contains several text boxes which calculate the prices of the party booking, outstanding balances based on values of deposits etc. I was so far happy with how everything was working but I fear I may have tried to run before I could walk!
Basically, the next stage is to set up mail merge emails to confirm bookings, prices, outstanding values etc but it has become obvious the word cannot merge a calculated value from a form as it is not saved to a table. Obviously sending information about prices and balances is crucial for the emails we send, so how would I go about doing this?
I had read it was bad practice to save a calculated value to a table, (which is the only solution my novice brain can see unfortunately!) so how could I merge a calculated value without doing this? Not sure if i'm going about this problem wrong or if the structure of my database is just flawed for what I'm trying to do.
Thanks in advance for any help!