Hi All-
I'm currently working on putting together an invoice in the form of a report and I'm having some trouble figuring something out.
One of the fees that our clients get charged is dynamic, but it also doesn't always exist. I'm having trouble setting up a dynamic field that Access will automatically ignore if the client does not have this fee.
The source table has a field [DynamicFee] which is a text field whose only entries are "Yes" or "No", and the report is run through a query, and pulled up using a button on a form.
I've tried everything from a switch function on the report (Switch([DynamicFee]="Yes", [FeeHere], [DynamicFee]="No",0), referencing a control on the report. I've tried the same thing referencing a control on the form, I've tried putting the switch function directly into the query, but no matter what I do the report always queries users [FeeHere].
If anyone could help me it would be greatly appreciated!
I'm currently working on putting together an invoice in the form of a report and I'm having some trouble figuring something out.
One of the fees that our clients get charged is dynamic, but it also doesn't always exist. I'm having trouble setting up a dynamic field that Access will automatically ignore if the client does not have this fee.
The source table has a field [DynamicFee] which is a text field whose only entries are "Yes" or "No", and the report is run through a query, and pulled up using a button on a form.
I've tried everything from a switch function on the report (Switch([DynamicFee]="Yes", [FeeHere], [DynamicFee]="No",0), referencing a control on the report. I've tried the same thing referencing a control on the form, I've tried putting the switch function directly into the query, but no matter what I do the report always queries users [FeeHere].
If anyone could help me it would be greatly appreciated!