PDA

View Full Version : Solved: Sort,format to report sheet



Rob342
03-15-2012, 01:05 PM
Hi Guys

I have a database called DBase and i am trying to get this into a report.
The claim no is unique in itself but could have A to Z lines

How can i sort down the Database and grab all the data for all the lines apertaining to that claim to get this into a report.

I have attached an example of the DBase & Rep & the format it needs to be, or something along those lines.

I have a pivot table on the org copy but the end users dont know how to use them.

If somebody can point me in the direction, that would be great

Many Thanks

mohanvijay
03-15-2012, 08:35 PM
Transfer DBase into MS Access and get the data by using ADO

Rob342
03-16-2012, 06:10 AM
mohanvijay
Thanks for the reply, but i need to do this in Excel.
If i can get the 1st part thats looping get the claim no & no of lines then i could finish the formatting myself.

Rob