Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: mrccopeland
- Content: Threads
- Order by date
-
Read a Lotus Notes View into Excel via Excel VBA
Hello All, I've searched the documentation here on vba and lotus notes but have come up short. Most topics here deal with sending messages via lotus notes. The problem I have here deals with reading the contents of a view and writing those contents back to excel. I assume you could use...- mrccopeland
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Sum Datediff Select problem
Hello All, I'm having a terrible time at this and don't quite know how to go about it (so I'll just jump right in). Say you have 2 tables: TableA ------- empsys epssys paysys beginningDate endingdate TableB -------- epssys paysys BegDate EndDate Table A is linked to Table B by epssys and...- mrccopeland
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
Query woes, trying to count transactions for multiple days
Hello All, I'm having a bit of a difficult time here. I have a query that I can run for a single day and it produces the correct output for the situation. The query goes as follows: SELECT DATEPART(mm, entrydate) AS tranmonth, DATEPART(dd, entrydate) AS tranday, DATEPART(yyyy...- mrccopeland
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
