Steps:
1, every input sales and account receivable (cash or transfer receipt)
2. After the input, generate customer check list for the client, and the format is in table 2 template, according to the date of the customer and account receivable (paid amount, of the template for cash and transfer payment receivable),
3. The customer listing some have corresponding phone, corresponding to the phone and phone access from table customers,
Customer name + 4. The last phone.xls files, which are customer files automatically saved in the root directory of the daily sales table a "customer list" folder,

CodePudding user response:

Four questions below will be YongFu!

CodePudding user response:

This thing, whether you use database access, SQL lite or more advanced database processing is better than the excel is simple, the simple one or two SQL statements can solve,

CodePudding user response:

refer to the second floor chewinggum response:

this matter, whether you use database access, SQL lite or more advanced database processing is better than the excel is simple, the simple one or two SQL statements can solve,

Anecdotal hearsay, Excel also support manipulated by the SQL statement,

CodePudding user response:

reference zhao4zhong1 reply: 3/f

Quote: refer to the second floor chewinggum response:

This thing, whether you use database access, SQL lite or more advanced database processing is better than the excel is simple, the simple one or two SQL statements can solve,

Anecdotal hearsay, Excel also support manipulated by SQL statements,

Support, with MS query can be used, however if the format of the data set, all kinds of errors, and often in sheet will have all kinds of beautiful to empty a line or two merged cell, the SQL statement is meng, personal point of view, to make data is pure, without any modification of basic data, excel for non-specialists a small amount of data by hand or personalized not frequently repeated processing, to make full automatic, try to reduce the effects of artificial data link,

CodePudding user response:

SQL can rely on large data, AI, ML automatically correct and fix common errors in various input data format is a tendency toward the next version of SQL,
Is the same and spell check and automatic correction,
I think,

Is a computer to adapt to the person; Instead of people to adapt to the computer,