Hello,
Happy Holidays! I have a database that includes many currency fields. I generate invoices from this information. My company produces training programs for other companies. There is a program fee which is charged to every client; however, there are other expenses that may or may not apply depending on the user's response to particular questions. For example, the user will check a box ("Client Paying Travel?) if the client is paying for travel for the trainer ('True' or 'False' value). I have created queries calculating the possibilities. Now I would like to display the results on a form for viewing purposes and create a report (invoice to the client). The problem is that sometimes the client will pay only up to a certain amount. There is a currency field for this value as well ("Amount Paid By Client"). If this field is null, and the user answers True to the "Client Paying Travel?" question, it is assumed that the client will pay full amount of travel.....no problems. Here's my confusion:
-User answers True to "Client Paying Travel?"
-User enters a figure (let's say $400.00) into the "Amount Paid By Client" field
-Actual travel may be less than, more than, or equal to the amount the client will pay
-If the actual travel is less than $400.00, the client pays the program fee plus the actual travel
-If the actual travel is more than or equal to $400.00, the client pays the program fee plus $400.00.
How can I display this information on a form and then generate a decent looking invoice to the client???? Sorry for the long-winded question......just wanted to be sure I gave enough information.......
Thanks much,
Pat
Happy Holidays! I have a database that includes many currency fields. I generate invoices from this information. My company produces training programs for other companies. There is a program fee which is charged to every client; however, there are other expenses that may or may not apply depending on the user's response to particular questions. For example, the user will check a box ("Client Paying Travel?) if the client is paying for travel for the trainer ('True' or 'False' value). I have created queries calculating the possibilities. Now I would like to display the results on a form for viewing purposes and create a report (invoice to the client). The problem is that sometimes the client will pay only up to a certain amount. There is a currency field for this value as well ("Amount Paid By Client"). If this field is null, and the user answers True to the "Client Paying Travel?" question, it is assumed that the client will pay full amount of travel.....no problems. Here's my confusion:
-User answers True to "Client Paying Travel?"
-User enters a figure (let's say $400.00) into the "Amount Paid By Client" field
-Actual travel may be less than, more than, or equal to the amount the client will pay
-If the actual travel is less than $400.00, the client pays the program fee plus the actual travel
-If the actual travel is more than or equal to $400.00, the client pays the program fee plus $400.00.
How can I display this information on a form and then generate a decent looking invoice to the client???? Sorry for the long-winded question......just wanted to be sure I gave enough information.......
Thanks much,
Pat
