Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
"select t.opendate as 'OpenDate', t.Transact as 'Transaction', t.NetTotal as 'HeaderNet', isnull(sum(d.Quan*d.CostEach), 0) as 'DetailNet', t.FinalTotal as 'HeaderFinal', t.TenderTotal as 'HowPayAppTotal' " _ & "from dba.posDetail d, " _ & "(select h.opendate, h.Transact, h.NetTotal, h.FinalTotal, sum(p.Tender) TenderTotal " _ & "from dba.posHeader h, dba.howpayapproved p " _ & "where h.Transact = p.Transact and h.opendate between " & lbl_SrchStartDate.Text & " and " & lbl_SrchEndDate.Text & " group by h.opendate, h.Transact, h.NetTotal, h.FinalTotal) t " _ & "where t.Transact *= d.Transact " _ & "and d.prodtype not in (101) " _ & "and opendate between " & lbl_SrchStartDate.Text & " and " & lbl_SrchEndDate.Text & " " _ & "group by t.opendate, t.Transact, t.NetTotal, t.FinalTotal, t.TenderTotal " _ & "order by t.transact"
|MS Access Concatenate Field Strings Together From 2 Separate Tables Into One Field (Merge Combine Join)||10||49|
|SQL Syntax: How to Find Commonality Among Similar Results||2||32|
|how to extract a number from a MS SQL server string.||39||63|
|How to determine the value of a field after it has been selected from a varchar field of 1 table and converted to an INT type value and inserted into another Sybase table with a field type of INT ?||2||40|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!