Hello,
I have a text file(tab delim) with data and I want to create report. Here is the content of text file:
HD John Smith j.smith(eta)testmail.com
CT service 1 5$
CT service2 1 6$
CT service3 4 7$
FT total 6 18$
HD Cindy Surname c.surname(eta)testmail.com
CT ... ... and etc.
HD- is report header, CT-report content(invoice items), FT-footer.
Now I'm splitting this file to two tables, in first tbl is assigned customer id, in other tbl customer's invoice items. Then I create join query and out of it report.
The question is: is it possible, to create report out of this kind of file reports, without splitting? if yes, then how.
I have a text file(tab delim) with data and I want to create report. Here is the content of text file:
HD John Smith j.smith(eta)testmail.com
CT service 1 5$
CT service2 1 6$
CT service3 4 7$
FT total 6 18$
HD Cindy Surname c.surname(eta)testmail.com
CT ... ... and etc.
HD- is report header, CT-report content(invoice items), FT-footer.
Now I'm splitting this file to two tables, in first tbl is assigned customer id, in other tbl customer's invoice items. Then I create join query and out of it report.
The question is: is it possible, to create report out of this kind of file reports, without splitting? if yes, then how.
Last edited: