raghuprabhu
Registered User.
- Local time
- Yesterday, 18:21
- Joined
- Mar 24, 2008
- Messages
- 154
Hi All,
I have a small database. It has three tables "tblCountryNameAndNumber", "tblImportedData" and "tblService".
"tblCountryNameAndNumber" has names of 45 countries and "tblService" has three records.
The working table is "tblImportedData".
Not all countries have to people working for the company.
I need help to create 45 pay cables in txt file format like "Belgium 18Aug11.txt" with data .
If there is no data then that should ablo be created. For example "Jordan 18Aug11.txt" with no data, "Zero Report - 18Aug11.txt" which lists all countries reports without data and finally create a report "Oseas Pmts - 18Aug11.txt" which gives summary of all the payments.
I have included sample of all the reports required. All this are being done manually.
Any suggestions will be appreciated.
Thanks
Raghu Prabhu
I have a small database. It has three tables "tblCountryNameAndNumber", "tblImportedData" and "tblService".
"tblCountryNameAndNumber" has names of 45 countries and "tblService" has three records.
The working table is "tblImportedData".
Not all countries have to people working for the company.
I need help to create 45 pay cables in txt file format like "Belgium 18Aug11.txt" with data .
If there is no data then that should ablo be created. For example "Jordan 18Aug11.txt" with no data, "Zero Report - 18Aug11.txt" which lists all countries reports without data and finally create a report "Oseas Pmts - 18Aug11.txt" which gives summary of all the payments.
I have included sample of all the reports required. All this are being done manually.
Any suggestions will be appreciated.
Thanks
Raghu Prabhu
