Hello guys!
I hope that maybe someone here will be able to help me as I can't get one thing to work on my reports.
I will try to describe it in few words. I have a database in which I have enquiries. Each enquiry can be either a potential or a sale - potential, we quoted for something, sale - the quotation has been accepted, we will proceed with some work for them. I need to pull out sales and potentials for each month (or a selected month). Potentials are easy. But with sales I have 3 fields for payments (each with data obviously). And each of them can be made in a different month or some of them may be paid in the same month.
I do it with 3 querries then - each is checking the different payment (1st payment, 2nd payment etc) and whether it is in selected month. From there I have 3 reports based on these 3 queries. So I have report with sales with 1st payment in selected month, then report with sales where 2nd payment has been made in selected month, etc.
Now, I created a new report that would display as subreports those 3 reports and give the total amount paid in selected month. Each of subreports obviously has the total for it but my formula for total of these 3 sums displays an error
I was using this formula to display the all total in a text box:
=Sum([Payment1]![1st Payment])+Sum([Payment2]![2nd Payment])+Sum([Payment3]![3rd Payment])
Error I get is like this: #Error
Nothing else.
All help will be much appriciated.
THANKS!
I hope that maybe someone here will be able to help me as I can't get one thing to work on my reports.
I will try to describe it in few words. I have a database in which I have enquiries. Each enquiry can be either a potential or a sale - potential, we quoted for something, sale - the quotation has been accepted, we will proceed with some work for them. I need to pull out sales and potentials for each month (or a selected month). Potentials are easy. But with sales I have 3 fields for payments (each with data obviously). And each of them can be made in a different month or some of them may be paid in the same month.
I do it with 3 querries then - each is checking the different payment (1st payment, 2nd payment etc) and whether it is in selected month. From there I have 3 reports based on these 3 queries. So I have report with sales with 1st payment in selected month, then report with sales where 2nd payment has been made in selected month, etc.
Now, I created a new report that would display as subreports those 3 reports and give the total amount paid in selected month. Each of subreports obviously has the total for it but my formula for total of these 3 sums displays an error
I was using this formula to display the all total in a text box:
=Sum([Payment1]![1st Payment])+Sum([Payment2]![2nd Payment])+Sum([Payment3]![3rd Payment])
Error I get is like this: #Error
Nothing else.
All help will be much appriciated.
THANKS!
