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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
is dbnull error in asp.net sql "Invalid user of IS operator"
I get an error message saying: "Invalid use of Is operator in query expression " when i use the IS DBNULL in the following sql statement in asp.net: SELECT SUM(tblDailyHrs.TotSchHrs) AS TotalSch, SUM(tblDailyHrs.TotActHrs) AS TotalAct, SUM(tblDailyHrs.OverTime) AS TotalOt...- greenbird
- Thread
- Replies: 3
- Forum: Microsoft: ASP.NET
-
How to create temporary tables in Access
Can anyone tell me how to create temporary tables in Access?- greenbird
- Thread
- Replies: 9
- Forum: Microsoft: Access Tables and Relationships
-
How to Import Excel File into Access where Source Fields not Constant
How do you import an Excel file into an Access table, using code, and where the Excel fields are not constant regarding the total number of fields, and Excel field names may also be changing, from file to file?- greenbird
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Designing Accounting Systems - General Ledger
Does anyone know how to or have an overview on designing an accounting system, specifically a general ledger or an acccounts receivable system in MS Access?- greenbird
- Thread
- Replies: 5
- Forum: -General database discussion
