Hi,
totally frustrated........
I have a report, it creates an invoice summary from a table called invoices. So, if I do an invoice run for the month of April the summary reports displays the customer name and basic details of the invoice raised. The report is based on the invoice table.
I have a field on the report where I want to display the total amount of invoices raised for each customer. I have a public function GetTotal_Invtodate and using expression builder, I make the field =gettotal_Invtodate( Parameter1, parameter2)
I been round the forums and enabled macros, set trusted locations etc....my public functions are in the Module 1...so are independent, global functions.
When I run the report, the parameter box displays with the name of the function, I just click ok as I am not sure what to put in there, the report runs but the field in question has #Error
If I go into the immediate window and type ? gettotal_invtodate(p1,p2) I get the correct answer......
I am obviously doing something wrong but for the life of me I can't understand what it is.......my patience with Access is running on fumes right now
Any help, advice, guidance much appreciated
Thanks
Lee
totally frustrated........
I have a report, it creates an invoice summary from a table called invoices. So, if I do an invoice run for the month of April the summary reports displays the customer name and basic details of the invoice raised. The report is based on the invoice table.
I have a field on the report where I want to display the total amount of invoices raised for each customer. I have a public function GetTotal_Invtodate and using expression builder, I make the field =gettotal_Invtodate( Parameter1, parameter2)
I been round the forums and enabled macros, set trusted locations etc....my public functions are in the Module 1...so are independent, global functions.
When I run the report, the parameter box displays with the name of the function, I just click ok as I am not sure what to put in there, the report runs but the field in question has #Error
If I go into the immediate window and type ? gettotal_invtodate(p1,p2) I get the correct answer......
I am obviously doing something wrong but for the life of me I can't understand what it is.......my patience with Access is running on fumes right now
Any help, advice, guidance much appreciated
Thanks
Lee