1. Build a query to update [login to view URL] (query to be included behind [login to view URL] GL button)
1st AccountNo, AP Record DLineNo=1
2nd AccountNo, AP Record DliuneNo=2
3rd AccountNo, AP Record DLineNo=3, etc.
2. Create a query that will generate the output using tables GLTemp_H, GLTemp_L & GLTemp_D
The output query will be exported as CSV format , (comma) delimited no text delimiter
The format for the output file is as follows: refer doc
I will load a spreadsheet with more explanation on this output.
3. Format the Manager & Accountant output spreadsheets (produced from [login to view URL] Spreadsheets button :-
3.1. Fit column widths for all columns in all worksheets
3.2. Bold Titles for the columns
3.3. Current, LastMonth & 12MnthAvg columns to be formatted as currency, $ with 2 decimal places
3.3. OUTop20Calls format
3.3.1. CallDateTime dd/mm/yy hhmm
3.3.2. Seconds , between thousands 000
3.3.3. ChgExGST $, 2 decimal.
4. Place a message on [login to view URL] when reports are being generated
‘Report generation in progress, please wait’
This message should only appear when reports are being generated and should disappear when reports are complete
5. Place message in worksheets where data was not found
‘- no data found -
Ready to do this job. So far I do not have completed projects in Access in this site. Maybe your project will be the first?
From the Access, of course, familiar.