steven_lawrence
Active Member
I would like to be able to write a query/ww to extract the information on report "P01301 Reports by Address" into Excel/Word for a mail merge. This is on menu G0121.
The file the standard report works on is F0101JC but this does not contain the text memorandum fields held in F0016.
I cannot work out how to join F0101JC and F0016 as there are no obviousl common fields - any suggestions on how the standard report does this join so I can reproduce it in my query/ww.
Thanks
Steve.
++++++++++++++++++++++++++++++
Steven Lawrence
Finance Systems Manager
Coral Eurobet plc
Glebe House, Vicarage Drive,
Barking, Essex, IG11 7NS, UK
Tel: +44 (0)20 8591 5151
Fax: +44 (0)20 8591 8647
website: www.coral.co.uk
e-mail: [email protected]
++++++++++++++++++++++++++++++
The file the standard report works on is F0101JC but this does not contain the text memorandum fields held in F0016.
I cannot work out how to join F0101JC and F0016 as there are no obviousl common fields - any suggestions on how the standard report does this join so I can reproduce it in my query/ww.
Thanks
Steve.
++++++++++++++++++++++++++++++
Steven Lawrence
Finance Systems Manager
Coral Eurobet plc
Glebe House, Vicarage Drive,
Barking, Essex, IG11 7NS, UK
Tel: +44 (0)20 8591 5151
Fax: +44 (0)20 8591 8647
website: www.coral.co.uk
e-mail: [email protected]
++++++++++++++++++++++++++++++