@Noob_2048 Like it was already advice, a Calculated field should not be store.
But I ask this. You said the BedCharges get calculated based on a "constant" for the day.
What happens in the case you want to generate the receipt for a patient visit 2 years ago, when the price for the bed may...
I am not very experience but I gave it a shot. It creates two types of files using the DoCmd.Outputto & DoCmd.TransferText
Hope this helps you in any way..
Well Friends I posted the same question on another forum and I was lucky to also get help there as well.
I finally got what I needed to work thanks to the help from another forum member. I was made to see that I had a problem with how I was buildind my Filter String and a Simple Parenthesis...
Hi MarkK Thank you for your reply.. I added the comparison Operators ( = ) to the filter string and It returns and error (I get error even If a Select one item from each listbox).
Attached 4 images one is a msgbox showing the String that will be used as a filter, and the second is the error...
Hi everyone,
Since I started using Access I have made it so far without asking too many questions but now I am stuck and need assistance..
Included in the zip. is a working version of my problem.
My table "EmpTraining" will store 5 fields:
ID (PK Autonumber )
EmpID (From Employees Table)...