Help on report

%3CLINGO-SUB%20id%3D%22lingo-sub-2336668%22%20slang%3D%22en-US%22%3EHelp%20on%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2336668%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20in%20need%20of%20help%20with%20a%20report.%20I%20need%20to%20report%20on%20client%20rental%20amount%20and%20the%20revenue%20generated%20by%20the%20client.%20My%20query%20pulls%20this%20data%20fine%20(line%20by%20line)%2C%20however%20I%20need%26nbsp%3B%20to%20report%20the%20client%20rental%20amount%20in%20a%20row%20and%20the%20revenue%20for%20each%20month%20in%20a%20separate%20column.%20How%20do%20I%20go%20about%20doing%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ER%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2336668%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2337113%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20on%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1048193%22%20target%3D%22_blank%22%3E%40Rumallen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20define%20%22...revenue%20for%20each%20month...%22%20as%20compared%20to%20%22...client%20rental%20amount....%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi All.

 

I am in need of help with a report. I need to report on client rental amount and the revenue generated by the client. My query pulls this data fine (line by line), however I need  to report the client rental amount in a row and the revenue for each month in a separate column. How do I go about doing this?

 

Any advice would be greatly appreciated.

 

Thanks

R

1 Reply

@Rumallen 

Please define "...revenue for each month..." as compared to "...client rental amount...."