Hello people.
Could you please help me. This one is a little hard to explain so i;ll try my best.
I have an invoicing system. I Open the form, select which job i want to invoice on from the left list box, then the appropriate task no's for that job appear in the right list box. i select which task no's i wish to invoice and then click invoice. This opens the report with all the info and calculations on it in a nice layout. However, i cannot get a task description on this report, as it is not in the query, and if i put it in the query it produces a cartesian number. Is there another way of getting that field on my report? Perhaps from the form as i have the tasks i want on the report selected already?
I hope someone has an idea because this is driving me insane!
Ta
Alexi
Could you please help me. This one is a little hard to explain so i;ll try my best.
I have an invoicing system. I Open the form, select which job i want to invoice on from the left list box, then the appropriate task no's for that job appear in the right list box. i select which task no's i wish to invoice and then click invoice. This opens the report with all the info and calculations on it in a nice layout. However, i cannot get a task description on this report, as it is not in the query, and if i put it in the query it produces a cartesian number. Is there another way of getting that field on my report? Perhaps from the form as i have the tasks i want on the report selected already?
I hope someone has an idea because this is driving me insane!
Ta
Alexi