|
|
#1
14-Aug-2004, 23:31
|
|||
|
|||
SQL-Mathematical functionHi - hopefully this is an easy query for any experts out there!
Suppose I want to know the cust_name & order_no with invoice date > 30 days & 60 days old from the date of invoice, how do I query against a Microsoft Access table via vb6.0 shown on a data report. Table: The result should show as below: Customer name Order No > 30 DYS > 60 DYS Total A A0001 4000 4000 B B0001 5000 5000 ---------------------------------------- 4000 5000 9000 9 ======================== can anyone help? Thanks From  ebbie |
Recent GIDBlog
First week of IA training by crystalattice
| Thread Tools | Search this Thread |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Revising Script style ?????? | pepee | MySQL / PHP Forum | 4 | 14-Apr-2004 04:59 |
| Strange behaviour in printf (interesting) | nusstu | C Programming Language | 9 | 05-Apr-2004 13:36 |
| Another problem dealing with main() and driver function | tommy69 | C Programming Language | 4 | 20-Mar-2004 19:46 |
| calling functions within a function | spudtheimpaler | C Programming Language | 5 | 02-Mar-2004 08:02 |
Network Sites: GIDNetwork · GIDWebHosts · GIDSearch · Learning Journal by J de Silva, The
