I took over an old Co-Workers Program and there are some people wanting a few changes.
The only issue I'm having is on a report that is pulling from a few Queries.
Its pulling the sum of the Total Time field When the Type field = AO.
Well now they want to also be able to see the sum of the Total Time field when the Type field = PO.
I just copied and pasted the Query that is pulling the AO and changed it to PO and it works just fine. But the field name is the same so when I add it to the main Query and then the report its having issues.
What is the best way to go about doing this without having to completely redo the report?
I've though about housing the PO data on a separate table and somehow adding that to the Main Query but I'm not sure that is going to work correctly.
The only issue I'm having is on a report that is pulling from a few Queries.
Its pulling the sum of the Total Time field When the Type field = AO.
Well now they want to also be able to see the sum of the Total Time field when the Type field = PO.
I just copied and pasted the Query that is pulling the AO and changed it to PO and it works just fine. But the field name is the same so when I add it to the main Query and then the report its having issues.
What is the best way to go about doing this without having to completely redo the report?
I've though about housing the PO data on a separate table and somehow adding that to the Main Query but I'm not sure that is going to work correctly.